Table of Contents
You want to know How to Add Header and Footer in Microsoft Excel, and then print them out, right? You can learn how to add headers to the top of a worksheet and footers to the bottom of a worksheet by reading this blog post. After that, you can print the headers and footers when you print the worksheet. It is possible to insert information about the document into the Header and Footer sections.
This includes the name of the document, the copyright, the sheet name, page numbers, the number of pages, and the date the document was created. Header text is typically positioned at the top of a page, while footer text is typically positioned at the bottom of a page. This information provides the user with an explanation regarding the document.
Excel provides you with a few headers and footers that are already preformatted and built-in, making it feasible for you to easily add them to your document. You have the ability to insert these headers and footers, and then edit them according to your requirements. It’s possible that you’ll request that the header include the company name and logo, and that the footer include the page numbers. In the Page Layout view and on printed pages, headers and footers are the only elements that are displayed. Here are the steps how to Add Header and Footer in Microsoft Excel.
Using the Insert Tab

- Click anywhere in your worksheet.
- Go to the Insert tab.
- In the Text group, click Header & Footer.
- Excel will switch to the Page Layout view and display the header and footer sections at the top and bottom of the worksheet.
- Click in the Header or Footer section where you want to add text.
- Type your desired text, including formulas, date and time functions, or even pictures.
- You can format the text using the formatting options available on the Header & Footer Tools tab that appears automatically.
- To exit the header and footer editing mode and return to the normal view, click anywhere in the worksheet outside the header and footer sections.
Using the Page Setup Window
- Click anywhere in your worksheet.
- Go to the Page Layout tab.
- In the Page Setup group, click Margins.
- In the Page Setup window, click the Header/Footer tab.
- Choose the Different first page header from even pages option if you want different headers for the first page and even/odd pages.
- Click in the Header or Footer section and type your desired text.
- You can format the text using the formatting options available in the Header & Footer section of the Page Setup window.
- Click OK to close the Page Setup window and return to the worksheet.
- Looking More Professional: The headers and footers make the Excel document look more polished and professional. They let you add important details like the title of the document, page numbers, and the date, giving it a consistent and expert look.
- Identification of the Document: Headers can have important details like the title of the document, the name of the author, or information about the version. This helps you quickly figure out what the spreadsheet is about and what it means.
- Page Numbers: Putting page numbers in the headers or footers of Excel documents with many pages makes it easier for users to move between them. It makes the length of the document clear and makes it easier to find specific information.
- Repetition of Information: Headers and footers let you put the same information at the top and bottom of each page. You could, for example, repeat column or row labels to help people understand the information on each page.
- When a business puts their logo, company name, or other branding elements in the headers and footers, it’s called branding. This makes sure that the document always looks professional and branded.
- Legal and Compliance Needs: You can put disclaimers, copyright information, and other legal and compliance-related information in headers and footers. For documents that need to follow certain rules, this is especially important.
- Professional Appearance: Footers enhance the overall appearance of the spreadsheet, providing a polished and professional look.
- Consistency: They help maintain consistency by allowing you to include common information (e.g., page numbers, document title) across all pages.
- Page Identification: Footers are useful for including information such as page numbers, making it easy to identify the sequence and location of pages within a large spreadsheet.
- Branding: You can use footers to add branding elements, such as company logos or copyright information, reinforcing the identity of the document.
- Reference Information: Important reference details, like file paths, author names, or modification dates, can be included in footers for quick reference.
- Legal Compliance: Footers are beneficial for incorporating legal disclaimers, copyright notices, or other required information to ensure compliance with regulations.
- Print Settings: They allow you to specify print settings, like repeating rows/columns or specifying what content to print on each page, contributing to better printout control.
Conclusion
In the mystical world of Excel, headers and footers are the keys to giving your creations a touch of elegance and organisation. They are also the keys to a more organised layout. Imagine your insights being neatly displayed at the top or bottom of each printed page, directing your readers through the enchanted data landscape.
This is what you want to happen. When you set out on this journey, keep in mind that the right incantations have the potential to transform your spreadsheet from something mundane to something enchanting.
Questions and Answers
The controls for the header and footer can be found in the Header & Footer group of the Insert tab with the following command: Insert > Header & Footer. Sections that are located at the top and bottom of the document are referred to as headers and footers, respectively.
You can quickly navigate to the header by using the Alt+V, H shortcut that is included in Word. This shortcut is very simple to use. In order to access the H key, press the Alt key and the V key simultaneously. There is no obligation for you to continue holding down the Alt key while you press H; the decision is entirely yours.
Before clicking the Header or Footer command, select the Insert tab and then click it. In this particular illustration, we will select the Header command. The menu that appears will allow you to select the preset header or footer that you want to use. You will see either the header or the footer.
A Microsoft specialist from TEVTA Author has 689 answers and 170.7K answer views in 10 months. In Excel, a header is a worksheet section that appears at the top of every printed page. It typically includes the worksheet’s title, date, page number, and other relevant information.