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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.