HDTutorial
EN
How to Make address book in Excel 2010

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Make address book in Excel 2010

144,988 views October 26, 2013 1:08

Watch on YouTube
ChannelExcel, Word and PowerPoint Tutorials from Howtech

Description from the creator

This tutorial will show you how to create a useful address book in Excel

Don't forget to check out our site howtech.tv/ for more free how-to videos!
youtube.com/ithowtovids - our feed
facebook.com/howtechtv - join us on facebook
plus.google.com/103440382717658277879 - our group in Google+

In this tutorial you are going to learn how to make address book in excel which has many useful functions, such as using for mail merge.

Step # 1 -- Creating the Headings

Start a new sheet in Excel where you are going to make the address list. At the head of each column type the data you want to store. In this example we are storing, "First Name", "Last Name", "Address Line 1", "Address Line 2", "Post/ZIP code" and "Notes". This data should all be in separate columns so you can easily use mail merge with the sheet later.

Step # 2 -- Format the Headings

Now adjust these columns so they roughly fit the data the data you are going to enter. Bold these titles as well so they appear different from the data that will appear below.

Step # 3 -- Additional Features of an Excel Address List

Enter the addresses you want to store to the sheet and this is how to make address book in excel. Excel has many features that allow you to customize the address list, for example you can highlight entries that you might regularly use, or easily delete someone from the sheet by using the delete row option.

About this tutorial

Excel, Word and PowerPoint Tutorials from Howtech published this 1:08 video tutorial on October 26, 2013. It has been watched 144,988 times on YouTube.

Duration
1:08
Published
October 26, 2013
Views
144,988
Likes
164

Tags

Share

Further reading

  • Create and print mailing labels for an address list in Excel ... support.microsoft.com

    To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. Here are some tips to prepare your data for a m…

  • Address books - Office.com templates.office.com

    Microsoft address book templates can help. With an address book template, you can create a single contact list for everyone in your circle. They’re great for clubs, too—download a membership directory template as your m…

  • How to Create an Address Book in Excel | Techwalla techwalla.com

    Save a version of the worksheet as a template to create future address books with a consistent style. Select "Excel Template ( .xltx)" in the Save As Type field in the Save As dialog box. To find this template, press "W…

This tutorial in other languages