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.