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

Headers and Footers 291
Figure 5-12:
A spread- sheet
in Page Layout view showing the custom footer.
After selecting the Different First Page check box, go ahead and define the unique header and/or footer for just the first page (now marked First Page Header or First Page Footer). Then, on the second page of the report, define the header and/or footer (marked simply Header or Footer) for the remain- ing pages of the report. (See “Adding a ready-made header or footer” and “Creating a custom header or footer” earlier in the chapter for details.)
Use this feature when your spreadsheet report has a cover page that needs no header or footer. For example, say you have a report that needs the cur- rent page number and total pages centered at the bottom of all pages but the first, cover page. To do this, select the Different First Page check box on the Design tab of the Header & Footer Tools contextual tab on the Ribbon and then define a centered stock footer that displays the current page number and total pages (Page 1 of ?) on the second page of the report, leaving the Click to Add Footer text intact on the first page.
Excel correctly numbers both the total number of pages in the report and the current page number without printing this information on the first page. So if your report has a total of six pages (including the cover page), the second page footer will read Page 2 of 6; the third page, Page 3 of 6; and so on, even if the first printed page has no footer at all.
Book II Chapter 5
Printing Worksheets