How to Add Headers and Footers to Excel Documents

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 add a text box. When you want to print a spreadsheet, on the other hand, you might need a uniform header and footer on every page.

Step

Open the View tab and switch to Page Layout view. Headers and footers only appear and are only editable in this view.

Page Layout also splits the spreadsheet into paper-sized pages.
Page Layout also splits the spreadsheet into paper-sized pages.
credit: Image courtesy of Microsoft

Step

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.

The Design tab only appears after clicking the header.
The Design tab only appears after clicking the header.
credit: Image courtesy of Microsoft

Step

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.

Two ways to create a footer.
credit: Image courtesy of Microsoft

Step

Open File and click Print to print or see the print preview, including headers and footers.

Header in print preview.
credit: Image courtesy of Microsoft