Microsoft Office Tutorials and References
In Depth Information
Adding headers and footers to printed pages
TIP If you have a chart selected when you click the Header & Footer button on the Insert
tab, Excel displays the Header/Footer page of the Page Setup dialog box instead of opening
a header or footer section for editing.
When you click a header or footer section, Excel displays the Design tool tab on the ribbon.
The Design tool tab contains several standard headers and footers, such as page numbers by
themselves or followed by the name of the workbook. To add an Auto Header to your
workbook, display the Design tool tab and then, in the Header & Footer group, click Header. Then
click the header you want to apply. The list of headers that appears will vary depending on
the properties and contents of your worksheet and workbook.
You can also create custom headers by entering your own text or by using the commands
in the Header & Footer Elements group to insert a date, time, worksheet name, or page
number. You can also add a graphic, such as a company logo, to a header or footer. For
example, if you include a worksheet in a printed report that is distributed outside your
company, adding your company’s logo to the worksheet can identify the worksheet with your
company. After you insert a graphic into a header or footer, the Format Picture button in
the Header & Footer Elements group will become available. When you click that button, a
dialog box opens with tools for editing your graphic.
When you print or display a worksheet, you might want to have different headers for odd
and even pages. For example, Consolidated Messenger’s document standards might require
the current date on odd-numbered pages and the page number on even-numbered pages.
To establish different headers and footers for odd-numbered and even-numbered pages,