File - Workbook Page Setup

Ribbon bar. Select the Workbook tab. In the Tools group, click Header/Footer to display the Workbook Header/Footer dialog box.

Classic menus. On the File menu, select Workbook Page Setup to display the Workbook Header/Footer dialog box.

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