Microsoft Office Tutorials and References
In Depth Information
Adding Headers and Footers
Adding Headers and Footers
There’s still another way to engineer your printout so that the same text appears at the
top (or the bottom) of every page: by adding a header and/or footer. As with Word,
headers and footers feature recurring text on every printed page, such as the name of
the designer of the spreadsheet, the current page number, the date on which the
worksheet was printed, or really anything you want to see there.
Now, introducing headers and footers into a printout may trigger a question: Doesn’t the
Print Titles feature just discussed do the same thing that headers do—namely, repeat
some selected text across the top of every page?
The answer is, sort of. It’s true that the Print Titles select-a-row selection and page
headers both emblazon the tops of printed pages with text, but there’s a difference: the
Print Titles option grabs its data from rows on the actual worksheet, while header and
footer data is entered in a separate area external to the worksheet, so it won’t be found
in any cells. Thus, you’ll never see header data in A1. If you do want to see the data in
row 1 at the top of each page, use Print Titles.
Adding Headers and Footers in the Page Layout View
As usual, there are a couple of ways to compose a header or footer. One is to enter it in
the Page Layout view, which offers another way of viewing a worksheet; it’s accessible
via the Workbook Views button group (see Figure 10–40).
Figure 10–40. Where to find the Page Layout button.
Click that button while in the PivotTables worksheet and you’ll see the screen shown in
Figure 10–41.
 
Search JabSto ::




Custom Search