How to Make Address Book in Excel 2010

In this tutorial you are going to learn how to make address book in excel which has many useful functions, such as using for mail merge.


Step # 1 – Creating the Headings

Start a new sheet in Excel where you are going to make the address list. At the head of each column type the data you want to store. In this example we are storing, “First Name”, “Last Name”, “Address Line 1”, “Address Line 2”, “Post/ZIP code” and “Notes”. This data should all be in separate columns so you can easily use mail merge with the sheet later.

Entering the heading information

Step # 2 – Format the Headings

Now adjust these columns so they roughly fit the data the data you are going to enter. Bold these titles as well so they appear different from the data that will appear below.

Formatting the titles

Step # 3 – Additional Features of an Excel Address List

Enter the addresses you want to store to the sheet and this is how to make address book in excel. Excel has many features that allow you to customize the address list, for example you can highlight entries that you might regularly use, or easily delete someone from the sheet by using the delete row option.

Highlighting and deleting entries