You can make your workbook easier to read by adding worksheet names, pictures, dates, page numbers, and other things to your header. Excel has many of these predefined and ready for you to use, but you can also add your own text to a header.
Click Insert > Header & Footer.
Click the left, center, or right header box at the top of the page.
Tip: To add predefined information to a footer so it will print at the bottom of every page, click Design > Go to Footer, and then click the left, center, or right footer box.
Click Design, and then click one or more of the following elements to add them to your header.
Don’t worry if you see formulas rather than text or numbers in the header. For example, if you click Current Date, you’ll see &[Date], which is the formula Excel uses to insert the date. When you click outside of the header, the current date will be displayed.
Tip: Use the formatting options on the Home tab to customize the header elements. For example, if you want your sheet name to stand out, increase its font size so it’s bigger than the other elements in the header.
When the headers are set up the way you want, click anywhere in the worksheet, and then click View > Normal.
Why can’t I see the header?
Click View > Page Layout. Headers and footers show up only in Page Layout view, Print Preview, and on printed pages.