Modify Header/Footer

You can access the Modify Header/Footer dialog box in the following ways:
  • 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.
Option Description
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.