Microsoft Office Tutorials and References
In Depth Information
From Header to Footer
Creating first-page headers and footers
Excel 2013 enables you to define a header or footer for the first page that’s
different from all the rest of the pages. Simply click the Different First Page check
box to put a check mark in it. (This check box is part of the Options group of
the Design tab on the Header & Footer Tools contextual tab that appears when
you’re defining or editing a header or footer in Page Layout view.)
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 remaining
pages of the report (see “Adding an Auto Header and 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, suppose that you have a report that needs
the current page number and total pages centered at the bottom of all pages
except the 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.
Then define a centered Auto 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 will correctly number both the total number of pages in the report and
the current page number without printing this information on the first page.
For example, if your report has 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.
Creating even and odd page headers and footers
If you plan to do two-sided printing or copying of your spreadsheet report,
you may want to define one header or footer for the even pages and another
for the odd pages of the report. That way, the header or footer information
(such as the report name or current page) alternates between being
rightaligned on the odd pages (printed on the front side of the page) and being
left-aligned on the even pages (printed on the back of the page).
To create an alternating header or footer for a report, you click the Different
Odd & Even Pages check box to put a check mark in it. (This check box is in
the Options group of the Design tab on the Header & Footer Tools contextual
tab that appears when you’re defining or editing a header or footer in Page
After that, create a header or footer on the first page of the report (now marked
Odd Page Header or Odd Page Footer) in the third, right-aligned section of the