Microsoft Office Tutorials and References
In Depth Information
See Also For information about editing your workbook in Print Preview mode, see the
“Previewing Worksheets Before Printing” section later in this chapter.
Excel divides its headers and footers into left, middle, and right sections. When you
point to an editable header or footer section, Excel highlights the section to indicate
that clicking the left mouse button will open that header or footer section for editing.
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 contextual tab on
the ribbon. The Design contextual 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 contextual 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.