In Microsoft Excel, headers and footers appear only when you print a
spreadsheet. They do not appear on screen.
To preview the header and footer in Excel, go to the File menu
and click Print Preview.
To modify the header and footer in Excel, go to the View menu and
click Header and Footer.
Modifying headers and
footers before exporting (reports only)