How to Make an Address Book in Excel

By Carter McBride

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.

Step 1

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

Step 2

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

Step 3

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 4

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 5

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 6

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

Tips & Warnings

  • If you require more information for your address book, use row 1 to design headers for your additional information.