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