Free Phone Book Templates (Excel / Word)

A phone book template is a document that contains all of your contacts and their phone numbers. You can create your phonebook in a matter of minutes by using the Office 365 suite and Microsoft Excel. A digital spot is very beneficial where you can access all your contacts easily and efficiently.

Table of Contents

What is a phone book?

Nowadays, a phone book acts as digital repositories that include a person’s contacts and their contact numbers, email addresses, mailing addresses, and more. Many professionals keep a phone book on hand invaluable to their workflow and efficiency.

How to create a phone book in MS Excel?

You can suppose that keeping a digital phone book might be a tiresome enterprise. With the help of MS Excel, you can create, manage, save, share, and update your phone book. Here are the steps to create a phone book in MS Excel;

At first, open a new file in MS Excel and then simply click and select all of the cells you need for your phone book. This includes usually 4-5 columns and a high number of rows. It is recommended to work with 50 or 100 for getting started as you can always add others later.
After that, click on the ‘Insert’ button with your rows and column selected. Make another box of options, under which you should click ‘Table.’ Then, classify your rows and columns that are known as cells in Excel, into categories.
After creating an inactive table in Excel, you can customize it according to your need. You should choose the topmost columns and name them as you want. For instance, you can go from Name to Phone Number, with Address occupying the middle cell.
Now, it’s time to start filling in the data. Under the ‘Name’ tab and start entering data. To navigate between cells, simply press the ‘Tab’ key on your keyboard. Then, save your excel sheet. You may also like Business Contact List Template.