• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Printing Spreadsheets > Working with Headers and Footers

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint