Modify Header/Footer

Ribbon bar. Select the View tab. In the Display group, click Header/Footer to display the Modify Header/Footer dialog box.

Classic menus. From the View menu, select Header/Footer to display the Modify Header/Footer dialog box.

Use these options to view the header and/or footer that is printed with a spreadsheet.

Header. In the Header box, choose from a list of predefined headers, which include headers with the file name, the page number, and combinations of the file name and page number. The header that you specify is shown in the display field below.

Footer. In the Footer box, choose from a list of predefined footers, which include footers with the file name, the page number, and combinations of the file name and page number. The header that you specify is shown in the display field below.

Custom. Click the Custom button to display the Custom Header/Footer dialog box, in which you can create your own unique header/footer. See Create a Custom Header or Footer for more details.

OK. When you are satisfied with your choices, click the OK button.

Cancel. Click the Cancel button to close this dialog box. Any changes made will be disregarded.