You can add information to a header so it’ll print at the top of every page. For example, you can create a header that contains page numbers to help your readers find pages in a printed worksheet .
On the Insert tab, in the Text group, click Header & Footer.
Click the left, center, or right box at the top of the worksheet, and then add the information you want.
Tip: To add information to a footer so it will print at the bottom of every page, click the Design tab, click Go to Footer in the Navigation group, and then click the left, center, or right footer box. To switch back to the header, click the Design tab, and then click Go to Header.
When the header is set up the way you want, click anywhere in the worksheet, click the View tab, and then click Normal.
Tip: Headers aren’t limited to just page numbers – you can improve the readability and style of your worksheet by adding predefined information like worksheet titles, dates, or pictures to your header.
Why can’t I see the header in my workbook?
Headers appear only in Page Layout view, Print Preview, and on printed pages.