Microsoft Office Tutorials and References
In Depth Information
Build a Custom Header and Footer
Build a Custom
Header and Footer
If you will be printing a workbook, you can
enhance the printout by building a custom
header and footer that includes information
such as the page number, date, filename, and
even a picture.
If you will be distributing hard copies of a
workbook, it is a good idea to include text that
helps the reader understand and read the
printout. This text could include the document
title, the filename, the page numbers, the
current date and time, explanatory text, and
You could add at least some of this text to the
actual worksheets, but Excel gives you a more
convenient method: the workbook header and
footer. The header is an area between the top
of the page text and the top margin, while the
footer is an area between the bottom of the
page text and the bottom margin. Excel offers
a number of tools that make it easy to build a
custom header and footer.
Display the Header
and Footer Tools
1 Click the View tab.
2 Click Page Layout.
Excel switches to Page
You can also click the
Page Layout button.
3 Click the Click to Add
Excel opens the header
area for editing.
Excel adds the Header &
Footer Tools tab.
4 Click the Design tab.