Page 305 - Excel 2013 All-in-One For Dummies

To create the centered header and footer for the report shown in Figure 5-11, I first chose
Income Analysis, Confidential, Page 1
from the Header button’s drop-down menu. (Income Analysis is the name of the worksheet; Confidential is stock text; and Page 1 is, of course, the cur- rent page number.)
To set up the footer, I chose
Page 1 of ?
from the Footer button’s drop-down menu (which puts the current page number, along with the total number of pages, in the report). You can choose this paging option from either the Header or Footer drop-down menu.
Headers and Footers 287
Figure 5-11:
The first page of a report in Page Layout view shows you how the header and footer will print.
Book II Chapter 5
Printing Worksheets