How to Make an Address Book in Excel

Updated March 23, 2017

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.

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

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

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 alphabetise your address book, you may want to enter the names in a last-name-first format.

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.

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.

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


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

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Carter McBride started writing in 2007 with CMBA's IP section. He has written for Bureau of National Affairs, Inc and various websites. He received a CALI Award for The Actual Impact of MasterCard's Initial Public Offering in 2008. McBride is an attorney with a Juris Doctor from Case Western Reserve University and a Master of Science in accounting from the University of Connecticut.