Get Customer Contacts Sheet

0:08 1:07 Suggested clip How to Make address book in Excel 2010 - YouTubeYouTubeStart of suggested clipEnd of suggested clip How to Make address book in Excel 2010 - YouTube

Select the cell or range of cells that you want to format. How to select cells or ranges? On the Home tab, click the Dialog Box Launcher next to Number. In the Category box, click Special. In the Type list, click Phone Number.

Select the cell or range of cells that you want to format. How to select cells or ranges? On the Home tab, click the Dialog Box Launcher next to Number. In the Category box, click Special. In the Type list, click Phone Number.

Make a simple outline and choose a template. Add quick facts about your company. Introduce new hire's to clients. Explain who your clients are. Add what drives your entity to success with the proper goals and objectives you need to reach.

Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern. ... Select the cells that contain the starting values. ... Drag the fill handle.

In Outlook, click People, select a Contacts folder, and add a New Contact Groupto the folder. Type a name for the group, click Add Members, and From Outlook Contacts. Next, open the workbook in Excel and arrange the worksheet so that the user Name column is adjacent to the Email address column.

You just need to write the extension of your co-worker's phone number in the ext column. Put also everyone's extension number which seems related to your job. Then, write their names on the name list to make your communication process easier. After that, writing the place, room or the department where they belong to.

Start a new spreadsheet in Microsoft Excel. Go to the "File" menu at the top of the window and select "New" from the drop-down menu. You will use this new blank spreadsheet to enter your contact information.