Microsoft Excel has become an increasingly versatile work application catering to most businesses, big and small. While most users are familiar with all the functions the app has to offer, many are still unaware that you can add a header or footer to your spreadsheets. With that in mind, it's time for a comprehensive view of what headers and footers are and how they work in Excel.
What are headers and footers?As with Word, Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in an Excel spreadsheet. They often contain descriptive text such as titles, dates, or page numbers displayed in page layout views and on printed pages.
Headers and footers are useful in providing quick information about your document or data in a predictable format and also help set out different parts of a document. Simply put, they make calculations, graphs, and pivot tables much easier to read and follow.
How to add and remove headers and footers:
- Select the spreadsheet for which you want to add headers or footers.
- On the Insert tab in the Text group, click Header & Footer; this displays the spreadsheet in page layout view.
- To add a header or footer, click on the left, right or center of the Header or Footer text box at the top or bottom of the spreadsheet page.
- You can now add a preset header or footer to your document, or create a custom header and footer.
- To start a new line in a header or footer text box, press ENTER; to include a single ampersand (&) in the text of a header or footer, use two ampersands. When you are done, click anywhere in the spreadsheet to close Header or Footer.
- Return to Normal page view by clicking on the View tab and Normal button.
- To remove the header or footer from a spreadsheet, select the View tab and click on Page Layout. Delete the information you want to remove.