2. Set Up Your Address Book Spreadsheet

Playback speed:

In this video, you will set up your address book spreadsheet with a clearly defined header row for categories such as names, addresses, phone numbers, and other important details.

Categorizing contact details makes it much easier and more efficient to find what you're looking for when it’s time to call or write to someone.

To begin, create column headings for each category of information you would like to organize.

You may want to include other column headings for other types of information important to you.

For example, you could include a column heading for the relationship of the contact to you, such as friends, family, or even for service providers you regularly use, like your doctor, mechanic, hair stylist, or your landlord.

You could also create a column heading for notes.

For example, you might need to make a note as a reminder that your friend is moving in a month and you’ll need to update their address then.

After you’re done adding column headings for the details you want to organize, it’s time to format them.

Bold the first row, so that your categories will stand out separately from the details you will add later.

Next, freeze the top row to keep your column headers visible when you scroll through your spreadsheet.

This is useful for spreadsheets that contain lots of information — you won’t have to remember what your headings are.

Then select the entire sheet, and wrap the text. Wrapping the text makes all of the words fit in a single cell, such as when you add lengthy information like addresses.

Now, it’s your turn: Add column headers to your spreadsheet for contact detail categories, Bold the header row, And freeze the header row.


  1. Add column headers to your spreadsheet for contact detail categories.
  2. Bold the header row.
  3. Freeze the header row.