Insert headers and footers

You can add headers to the top and footers to the bottom of a worksheet. When you print the worksheet, the headers and footers also print. For example, you might create a header with the file path and a footer with page numbers. Headers and footers display only in Page Layout view and on printed pages. Take this quick course to learn more.

Insert headers and footers

Learn what headers and footers are, where they're located, and how to print them in Excel. (2:10)

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Page numbers in depth

Adding page numbers to a worksheet is one of the most common uses of headers and footers. Watch this video to see how. (3:34)

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Header and footer details

To save time, add headers and footers to several worksheets at the same time, make them different on the first page. And format, move, or delete them. (4:02)

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

A brief reminder of the key points in this course summary.

More courses available at Microsoft Office Training.

See Also

Add a header to a worksheet

Insert the date in a footer

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×