How to Create an Address Book Using Open Office Calc
Open a new, blank spreadsheet., Right click on column A and select Column Width., 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...
Step-by-Step Guide
-
Step 1: Open a new
Enter in
1.19. ,,,, Change A1 to F1 to the following:
First Name Last Name Street City State Zip Code , Do this by selecting A1 to F1 and then clicking on the center alignment, as indicated in the screenshot. , The example ones are fictitious names and/or addresses. , 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...
Select the Numbers tab.
Select Number under the Category section.
Under Format, click General.
In the leading zeros box, change the number 1 to 5 This is how everything should look. , To know how to place the second page properly, click on the preview icon. , Look closely at your spreadsheet.
You will see some slightly darker and thicker lines.
Those are the edges of the printed page. ,,, You need to do that so the program that will be accessing the data (Writer, Impress, Calc) will know where to look. , This makes it so when the program looks for a name, it finds it. -
Step 2: blank spreadsheet.
-
Step 3: Right click on column A and select Column Width.
-
Step 4: Select columns B and C and enter in the width of 1.49.
-
Step 5: Change the width of column D and E to 0.99.
-
Step 6: Change the width of column F to 0.59.
-
Step 7: Name the columns.
-
Step 8: Center the column titles.
-
Step 9: Add the names of some people.
-
Step 10: Format the zip code column.
-
Step 11: Create a second page.
-
Step 12: Click on the Preview icon again.
-
Step 13: Select and copy (CTRL C) the title of the columns in A1 to F1 and paste at the top of the second page.
-
Step 14: Save as Address_Book or whatever is appropriate for your purposes.
-
Step 15: Register your Address Book spreadsheet as a data source.
-
Step 16: Assign the fields in the spreadsheet.
Detailed Guide
Enter in
1.19. ,,,, Change A1 to F1 to the following:
First Name Last Name Street City State Zip Code , Do this by selecting A1 to F1 and then clicking on the center alignment, as indicated in the screenshot. , The example ones are fictitious names and/or addresses. , 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...
Select the Numbers tab.
Select Number under the Category section.
Under Format, click General.
In the leading zeros box, change the number 1 to 5 This is how everything should look. , To know how to place the second page properly, click on the preview icon. , Look closely at your spreadsheet.
You will see some slightly darker and thicker lines.
Those are the edges of the printed page. ,,, You need to do that so the program that will be accessing the data (Writer, Impress, Calc) will know where to look. , This makes it so when the program looks for a name, it finds it.
About the Author
Kimberly Cook
Experienced content creator specializing in practical skills guides and tutorials.
Rate This Guide
How helpful was this guide? Click to rate: