Insert headers and footers

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

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.

Inside this course:

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

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

Header and footer details (4:02)
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.

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

More courses available at Microsoft Office Training.

See Also

Video: Insert headers and footers

Add a header to a worksheet

Video: Header and footer details

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!