Anita has lots of different addresses and contact names for all the suppliers of videos and DVDs to her store. She needs to keep all the addresses in one place, so she can quickly refer to them any time she needs to request new stock or pay for stock she already has. She decides to use a spreadsheet.

Creating a spreadsheet

Each spreadsheet is made up of rows (which are given a number) and columns (which are given a letter). Where each column and row meet is called a 'cell'. Each cell has a reference relating to the row and column it intersects, e.g. where column A and row 3 meet is cell A3.

Anita uses the following headings on her spreadsheet:

• Title
• First Name
• Last Name
• Address 1
• Address 2
• City
• Postal Code
• Telephone Number
• Email

Anita needs to put all her addresses within this spreadsheet under each of these headings. If she doesn't have data for any of these categories, she decides to just leave it blank.

If you are unable to view the Flash movie above, click here for a non-Flash alternative.

Go next to see how this contacts spreadsheet can help Anita save time when she uses a mail merge.