Microsoft Excel spreadsheets are an ideal way to store contact information. Having a phone book in Excel makes it easy to add and remove contact information. The creation of such a book consists of two main procedures: adding the appropriate column and entering the information.
Necessary
Installed Microsoft Excel 2007
Instructions
Step 1
Open Microsoft Excel 2007.
Step 2
Add a title at the top of the table so you know what it contains. You may need one phone book for personal use and another for work or business use. The name will help distinguish them from each other. Use the top toolbar to highlight the title.
Step 3
Skip a couple of lines to customize the phonebook columns. Use the following column headings: name, address, city, state, zip code, telephone number, fax number, and email address. Enter these headings for each of the columns. It is much easier to read and find information when the individual items are in separate columns.
Step 4
Highlight the row of column headings by clicking on the row number on the left. Use the tools in the top bar to center and bold the column headings.
Step 5
Enter information in each column. This may take some time. You just need to enter all the available contact information in Excel once, and then just add new contacts and update the information. If any data is missing, just leave the cell blank.
Step 6
Format the text in the postcode column. Select all text in the column (excluding headings). Right-click on the selection and select Format Cells. In the "Number" tab, click on the "Additional" item. Click on Postcode or Postcode +4. Click OK. This will convert all indexes to a single format.
Step 7
Format the text in the column of phone numbers. Select all text in the column except for the headings. Right-click and select Format Cells. In the "Number" tab, select "Additional". Click on the "Phone number" item in the "Type" section. Click OK. All phone numbers will be formatted.