How to Make an Address Book in Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make an Address Book in Excel
Keep your address book electronically with Excel. (address & phone book image by cegli from

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.

Skill level:


  1. 1

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

  2. 2

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

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

  4. 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.

  5. 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.

  6. 6

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

Tips and warnings

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.