Microsoft Office Tutorials and References
In Depth Information
Adding headers and footers to printed pages
Adding headers and footers
to printed pages
If you want to ensure that the same information appears at the top or bottom of
every printed page, you can do so by adding headers or footers. A header is a section
that appears at the top of every printed page; a footer is a section that appears at the
bottom of every printed page. To create a header or footer in Excel, you display the
Insert tab and then, in the Text group, click Header & Footer to display the Design
When you display your workbook’s headers and footers, Excel displays the workbook in
Page Layout view. Page Layout view shows you exactly how your workbook will look when
printed, while still enabling you to edit your file, a capability not provided by Print Preview.
You can also switch to Page Layout view by displaying the View tab and then, in the
Workbook Views group, clicking Page Layout.
SEE ALSO For information about editing your workbook in Print Preview mode, see
“Previewing worksheets before printing” 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 mouse button will open that header or footer section for editing.