You can insert header and footer information into your Excel worksheets to automatically display printable information such as page numbers, sheet names, file paths, and more. This is especially useful when you need to print or share your work with others.
To insert a header or footer code in Excel:
(Optional): If you want to include a built-in code such as page number or file path, click the Quick Parts drop-down in the Header & Footer Elements group. Then select the desired code from the list.
(Optional): If you want to insert your own custom information, click in the header or footer area where you want the information to appear. Then type the desired text directly into the header or footer.
(Optional): To format your header or footer text, select it and use the options in the Font, Alignment, and [Number Formatting]
(Optional): To insert a picture into your header or footer, click the [Insert Picture]
(Optional): To position your header or footer elements differently on odd vs even pages (or first vs subsequent pages), click the [Different Odd & Even Pages], or [Different First Page]