Working with Headers and Footers
Headers and footers provide you with a way to add page numbers, dates, sheet names, and other repeating items at the bottom or top of your spreadsheet printout, respectively. A header is printed on the line just above the top margin; a footer is printed on the line just below the bottom margin.
To Create Headers
1. |
Open the Page Style dialog box (choose Format, then Page). |
2. |
Click the Header tab (see Figure 12.9). Figure 12.9. The Header tab allows you to add repeating information to the tops of the pages in a spreadsheet.
|
3. |
Use the Spacing spin box to set the distance between the header and the data on the page. |
4. |
Use the Height box to set the size of the header box. |
5. |
Select the AutoFit height checkbox if you want the header size to change based on the amount of text it holds (this is the default, and if checked, it does not require that you set a height for the header). |
6. |
Use the Left and Right margin spin boxes to set the distance between the header and the left and right margins, respectively. |
7. |
If the header will be the same on both right and left pages, make sure the Same content left/right checkbox is selected. |
8. |
To place a border or background on the header, click the More button. You will be taken to a Border/Background dialog box that you can use to set the border and/or background settings (it provides the same settings as the Border and Background tabs on the Page Style dialog box). After completing the border/background settings, click OK to return to the Header tab. |
9. |
To actually insert the information that will be in the header, click the Edit button. The Header dialog box will open (see Figure 12.10). Figure 12.10. The Header dialog box allows you to create the content for a header.
|
10. |
Enter the information that you want to appear in the header at the left margin (Left Area), centered at the top of the page (Center Area), and in the right margin (Right Area). |
11. |
You can use the tools that are provided to automatically set or insert different information into the header. From left to right, these tools are: Text Attributes— Allows you to open the Text Attributes dialog box and set the font, font type, font style (bold, italics, etc.), and font color. Select the text that you want to format in the header before clicking the Text Attributes tool. File name— Inserts the name of the spreadsheet file. Sheet name— Inserts the name of the sheet. Page— Places a page number in the header. Pages— Places the total page count in the header used along with the Page tool. For example, you can specify page x of x, showing the current page number and the total number of pages. Date— Inserts the current date into the header. Time— Inserts the current time into the header. |
12. |
When you have set up the actual header text, click OK to return to the Header tab. |
To Create Footers
All the tools provided to create headers are also supplied to create footers, which place repeating information at the bottom of your printed spreadsheet pages.
1. |
Open the Page Style dialog box (choose Format, then Page). |
2. |
Click the Footer tab (see Figure 12.11). Figure 12.11. Footers are created on the Footer tab, using the same tools used to create headers on the Header tab.
|
3. |
Set the various parameters for footers as you did for headers (see the previous section). |
4. |
To enter the information for the footer, click the Edit button. In the Footer dialog box, input the information that will appear at the left, center, and right of the footer area. |
5. |
Use the tools provided to enter information such as the page numbering code or the current data. |
6. |
When you have entered the text for the footer, click OK. You will be returned to the Footer tab. |
To Select Sheet Attributes
Calc also provides you with the ability to determine the items in the spreadsheet to actually print and how to scale the print job; you can actually change the scale of the print area to try and fit that last little bit of information onto the printed page (rather than going to a second page). Sheet attributes are configured on the Sheet tab of the Page Style dialog box.
1. |
Open the Page Style dialog box (choose Format, then Page). |
2. |
Click the Sheet tab (see Figure 12.12). Figure 12.12. You can determine what items to print from the spreadsheet and how to scale the print job.
|
3. |
To select items that will be printed, select or deselect the checkboxes in the Print area. For example, to print formulas (so that you can view all the formulas and functions in the spreadsheet rather than the returned value), click the Formulas checkbox. |
4. |
To set how the printout will choose when to break to a new page, select either the Top to bottom or Left to right checkbox. Top to bottom reads the sheet from top to bottom to find the first page break and Left to right reads from left to right (placing page breaks as it reads from left to right). |
5. |
To select a different starting page number, use the spin box next to the First page number checkbox (which must also be selected). |
6. |
Use the Scale spin box to change the 100% scale to enlarge or shrink the actual print perspective on the printed pages. |
7. |
If you want the spreadsheet to be shrunk to fit on a certain number of pages, click the Max no. of pages option button and then use the spin box to select the number of total allowable pages. |
8. |
When you have set the sheet properties, click OK to close the dialog box. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.