How to Make an Address Book in Excel

Microsoft Excel is a spreadsheet program that works on Windows and Mac, and is part of the Microsoft Office software package. You can create an address book in Microsoft Excel, and continuously sort address data by names to keep your information in alphabetical order. You can use your Excel address book in conjunction with Word to print out address labels for all of your contacts, and Excel also allows you to update your address book if people change addresses or phone numbers.

...
Keep your address book electronically with Excel.

Step

Click the "Start" menu and go to "All Programs." Select "Microsoft Office" followed by "Microsoft Excel" to open Excel.

Step

Type "Name" in cell A1 of the spreadsheet, type "Address" in cell B1 and type "Phone Number" in cell C1.

Step

Enter the data for your address book, starting in the second row. Enter the information based on the headers you create in Steps 2 through 4, so column A has the person's name, column B has the person's address and column C has the person's phone number. If you plan to alphabetize your address book, you may want to enter the names in a last-name-first format.

Step

Click and hold the left mouse button on column A and move the cursor to column C to highlight columns A, B and C. Click "Home" and "Format." Select "AutoFit Column Width." This makes all the columns fit to the longest text in a cell in the column.

Step

Highlight A, B and C again. Click the "Data" tab. Click the button with an A above a Z and the arrow pointing down. This sorts the data by the person's name in alphabetical order.

Step

Click the "Office" button and "Save" to save your address book.