A Simple Address Book Template In Excel

Index

Address Book Template

With this template I can save all my addresses and phone numbers of the people I know. There are a few advantages of having an Excel address book on my computer over having it on paper: 

• When someone moves or changes their phone number, I can easily change it without making a mess in my paper address book

• If I save it in a place like Dropbox, Onedrive or Googledrive, I can always use it on all my devices connected to those boxes

• I can look up things in Excel in different ways compared to a 'normal' address book where I can only search alphabetically in the way I choose to note down alphabetically. In Excel I can look them up by name, surname, telephone number, etc.

Let's Take A Look At The Template

There are the following columns:

• Name

• Last name

• Subject

• Phone number 1-6

• E-mail

• Address

• Postal Code

• City

• Country

• Commentary

Search With Ctrl & F

I can look things up with ctrl + f. A box opens where I enter the name or number I want to look up. Then it searches for it and returns the results.

Search With Filter

At the top of the file I can see the filters. Open the filter. I can choose to sort alphabetically or choose all names with an e. The first sorts everything alphabetically by first name. I can sort alphabetically in each column. The second gives me all names that start with an e.

The Template Address book

The template Address book is part of the blog 'A Simple Address book Template in Excel'.