While header and footer rows are more typically used in Word documents, Excel supports this functionality as well. Headers and footers can be used for a variety of purposes. If you are looking to print your spreadsheet, they can be used to place page numbers, contact info and more, and even if you want to keep your files online, they have their uses – for example,if you want to add a watermark to your file.
Regardless of what you want to use them for though, in order to add headers and footers to your document, go to the Insert tab on your ribbon. There, under the Text section, you’ll find a button labelled ‘Header & Footer’.
Click on it, and your document will be split into pages, each with a header and footer.
You can edit the content of each of the sections (and the sections themselves) via the new ribbon menu option labelled ‘Header & Footer’. Clicking outside of the fields in said sections will hide that menu option again – you’ll have to click back inside the header to get it back.