Workbook Header/Footer

Ribbon bar. When a workbook is displayed, select the Workbook tab. In the Tools group, click Header/Footer to display the Workbook Header/Footer dialog box.

Classic menus. When a workbook is displayed, from the File menu, select Workbook Page Setup to display the Workbook Header/Footer dialog box.

Use these options to create a header and/or footer when printing the workbook as well as to specify which files will have a header and/or footer applied to them.

Apply Workbook header/footer to
You can either apply the header/footer to All supported documents or Only documents selected below. If you choose to apply the header/footer only to selected documents, scroll through the list and select which documents will have the header/footer.
Header
Select from a list of predefined headers (using the drop-down list), or click the Custom button and create a customized header. Once you have created a custom header, it will be displayed in the view box.
Footer
Select from a list of predefined footers (using the drop-down list), or click the Custom button and create a customized footer. Once you have created a custom footer, it will be displayed in the view box.