Open the Excel workbook
Go to the Insert tab
Click Header & Footer
Click in the left, center, or right header box
Type the header text
Use Header & Footer Tools to add page number, date, time, file name, or sheet name
Click outside the header area to finish
To edit an existing header, click the header area again and make changes
To remove a header, delete the header text from the header box
To set a different header on the first page or odd and even pages, use the Header & Footer Options
To print the header, use Print Preview or Page Layout view