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.