Microsoft Office Tutorials and References
In Depth Information
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 using 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 Header & Footer
Tools Design contextual tab.
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this topic.
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.