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)

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)

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)

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