How to Create an Address Book Using Open Office Calc

Compuware

Editor

posted on 13 years ago — updated on 1 second ago

12
views

More and more of our tangible objects are becoming electronic and digitalized. Since many people are increasingly more comfortable with using spreadsheets, having your address book turned into a spreadsheet is a great way to keep your contacts organized and up-to-date. This tutorial uses OpenOffice Calc, a free way to create spreadsheets that will help you to keep up with your family, friends, work and business contacts. Read on to learn how.

Steps

Open a new, blank spreadsheet.

Right click on column A and select Column Width. Enter in 1.19.

Select columns B and C and enter in the width of 1.49.

Change the width of column D and E to 0.99.

Change the width of column F to 0.59.

Name the columns. Change A1 to F1 to the following: First NameCreate an Address Book Using Open Office Calc Step 6Bullet1.jpg Last NameCreate an Address Book Using Open Office Calc Step 6Bullet2.jpg StreetCreate an Address Book Using Open Office Calc Step 6Bullet3.jpg CityCreate an Address Book Using Open Office Calc Step 6Bullet4.jpg StateCreate an Address Book Using Open Office Calc Step 6Bullet5.jpg Zip CodeCreate an Address Book Using Open Office Calc Step 6Bullet6.jpg

Center the column titles. Do this by selecting A1 to F1 and then clicking on the center alignment, as indicated in the screenshot.

Add the names of some people. The example ones are fictitious names and/or addresses.

Format the zip code column. You will notice that the zip with the leading zero is not showing the zero. Right click on the F column and then select Format Cells...Create an Address Book Using Open Office Calc Step 9Bullet1.jpg Select the Numbers tab.Create an Address Book Using Open Office Calc Step 9Bullet2.jpg Select Number under the Category section.Create an Address Book Using Open Office Calc Step 9Bullet3.jpg Under Format, click General.Create an Address Book Using Open Office Calc Step 9Bullet4.jpg In the leading zeros box, change the number 1 to 5Create an Address Book Using Open Office Calc Step 9Bullet5.jpg This is how everything should look.Create an Address Book Using Open Office Calc Step 9Bullet6.jpg

Create a second page. To know how to place the second page properly, click on the preview icon.

Click on the Preview icon again. Look closely at your spreadsheet. You will see some slightly darker and thicker lines. Those are the edges of the printed page.

Select and copy (CTRL C) the title of the columns in A1 to F1 and paste at the top of the second page.

Save as Address_Book or whatever is appropriate for your purposes.

Register your Address Book spreadsheet as a data source. You need to do that so the program that will be accessing the data (Writer, Impress, Calc) will know where to look.