Because Excel 2013 spreadsheets aren't broken into pages, Excel files don't often include headers and footers. Normally, if you wanted to add a note above or below your data, you would simply type it in a cell or . When you want to print a spreadsheet, on the other hand, you might need a uniform header and footer on every page.
Video of the Day
Open the View tab and switch to Page Layout view. Headers and footers only appear and are only editable in this view.
Click Click to Add Header and type the text for your header. To add dynamic elements, such as the page number, open the Design tab and choose items from the Header & Footer Elements section. Because headers and footers repeat on every page, you need to use these elements for data that varies by page.
Click Go to Footer on the Design tab or scroll down and click Click to Add Footer at the bottom of the page to design the footer. Adding a footer follows the same process as adding a headline.
Open File and click Print to print or see the print preview, including headers and footers.