How to Create an Address Book in Excel

Organize your address details for quick access with a sortable table created in Microsoft Excel. As an alternative, copy a Microsoft template and style a pre-designed address book to make the data meaningful. These time-saving layouts include table columns with a clearly defined header row for categories such as names, addresses and phone numbers. Each table column features a sorting button to sort the rows of data by alphabet or size to help you search and analyze your database of contacts.

Business meeting
Complement your paper address book with an Excel table for sharing.
credit: vm/iStock/Getty Images

Create Tables

Step

Click and drag to select the cells for your table. For example, select cells "A2:E50" to select a range with 5 columns and 50 rows.

Step

Click the "Insert" tab on the command ribbon and click "Table" in the Tables group to open the dialog box. Select "My Table Has Headers" and then click "OK" to create sortable columns with arrow buttons for sorting.

Step

Enter the category headers, such as First Name, Last Name, Address and Email.

Step

Click the table to bring up the Table Tools ribbon with the Design tab. Click the "Design" tab to show the style tools, such as the gallery of thumbnails in the Table Styles group. For example, click the "More" button in Table Styles to open the chart that includes the Custom, Light and Medium sections, then point over a color sample to preview the effect. Select the preferred thumbnail to update the table's color and design.

Step

Click a cell, type the data and then press "Tab" to move the cursor to the next cell.

Step

Press "Ctrl-S" to save this workbook.

Adapt a Template

Step

Click the "File" tab on the command ribbon and then select "New" to open the templates list.

Step

Enter "address book" (without quotations) in the "Search for Online Templates" box and press "Enter" to bring up the thumbnails in the search results. Examples include "Address Book," "Personal Address Book" and "Customer Contact List."

Step

Click a preferred template thumbnail to preview an enlarged version with its description, download size and rating. Click "Create" to copy this template to a new workbook.

Step

Click the table and update the format, layout or style with the ribbon tools and Table Tools options. For example, make the data more readable on the rows and columns by selecting or deselecting options, such as "Banded Rows" and "Banded Columns," in the Table Style Options group on the Design tab of the Table Tools ribbon.

Step

Click a cell, enter the contact's data and then press "Tab" to move the cursor to the cell in the next table column.

Step

Press "Ctrl-S" to save this workbook.