How to add a header and footer in Excel

On Microsoft Excel, you can add a header or footer to your spreadsheets when you want the printout to include the company's logo at the top of the page, or when you need to add the folio number at the bottom to keep everything organized.

However, if you want to fix up the spreadsheet, the Microsoft 365 version of Office, Role 2022, and older versions includes multiple ways to add and change the header and footer of the page, and in that location is even a way to utilize the same configuration other pages in the document without repeating the steps.

In this Windows 10 guide, nosotros volition walk you through the steps to create a header and footer in a Microsoft Excel document.

How to add together header and footer in Excel
How to add header and footer to all sheets in Excel
How to remove header and footer in Excel

How to add together header and footer in Excel

You can add a header and footer in at to the lowest degree two different ways through the Insert or Page Layout tab in Excel.

From the Insert tab

To insert a header and footer to an Excel sheet, utilise these steps:

Open Microsoft Excel.
Click the Blank document option in the "Home" department. (Or open up the document you want to customize.)
Click the Insert tab.
In the "Text" settings, click the Header & Footer choice.

Source: Windows Primal
Click the left, middle, or right cells at the tiptop to edit the custom header.

Source: Windows Fundamental
Click the left, center, or correct cells at the bottom to edit the custom footer.

Source: Windows Primal
(Optional) Use the "Header & Footer Elements" settings to insert predefined elements, including:
- Folio Number.
- Number of Pages.
- Current Engagement.
- Current Fourth dimension.
- File Path.
- File Name.
- Sail Name.
Source: Windows Central

Quick tip: If you don't see the settings, select the header or footer on the page to bring up the tab.

One time you complete the steps, the spreadsheet now will include a proper header and footer.

If you need to add a piece of text that includes an ampersand (&), and then you will need to use two ampersands (&&). If y'all need to exit the header or footer without applying changes, press Esc. You can click anywhere in the certificate to exist and apply the changes.

Utilise epitome for header or footer in Excel

To use an epitome for the header or footer, apply these steps:

Open Microsoft Excel.
Click the Bare document option in the "Dwelling house" section. (Or open the document you want to customize.)
Click the Insert tab.
In the "Text" settings, click the Header & Footer choice.

Source: Windows Primal
Click the Header & Footer tab.
Click the sheet header or footer.
In the "Header & Footer Elements" section, click the Picture show push.

Source: Windows Fundamental
Select the source to insert the epitome from, including:
- From a file.
- Bing Paradigm Search.
- OneDrive.
Source: Windows Central

Quick note: If y'all want to use an image from Bing, use the text box to search for a picture.
Select and insert the prototype.
(Optional) Click the Format Picture button if yous need to adjust the size, rotation, or scale.

Source: Windows Central

Quick tip: Click the header to make the tools available then click the Format Flick button.
Alter the image settings equally needed.

Source: Windows Primal
Click the OK push.

Later you complete the steps, the logo or the image you selected will be reflected in the document.

From the Page Layout tab

To add a header and footer with the Page Layout tab, use these steps:

Open up Microsoft Excel.
Open the document you want to customize.
Click the Page Layout tab.
In the "Page Setup" settings, click the Dialog Box Launcher push on the right side.

Source: Windows Central
Click the Header/Footer tab.
(Optional) Use the Header drop-down menu to select one of the available options to use a predefined header.

Source: Windows Cardinal
(Optional) Use the Footer drop-down menu to select i of the available options to utilize a predefined footer.
Click the Custom Header button.

Source: Windows Central
Click the Custom Footer button.
Select i of the sections (left, middle, or right) to bear witness the header or footer.
Compose a line of text for the header or footer.

Source: Windows Central
Select the text and click the Format Text (A) push button to mode the header text.
(Optional) Click one of the available buttons to insert a predefined header, including:
- Insert Page Number.
- Insert Number of Pages.
- Insert Engagement.
- Insert Time.
- Insert File Path.
- Insert File Proper noun.
- Insert Canvass Name.
- Insert Picture.
Source: Windows Key
Click the OK button.
Click the OK push button again.

Once you complete the steps, the header and footer volition be practical to the canvas y'all are editing. If you practice not see the changes, click the View tab, and then in the "Workbook Views" settings, click the Page Layout button.

Utilise paradigm for header or footer in Excel

To utilise the Folio Layout tab to add an paradigm for the header or footer, use these steps:

Open Microsoft Excel.
Open up the document you want to customize.
Click the Page Layout tab.
In the Folio Setup settings, click the Dialog Box Launcher button on the right side.

Source: Windows Key
Click the Header/Footer tab.
Click the Custom Header button.

Source: Windows Central
Click the Custom Footer push.
Select one of the sections (left, centre, or right) to show the header or footer.
Click the Insert Picture push button on the left side.

Source: Windows Central
Select the source to insert the prototype from, including:
- From a file.
- Bing Image Search.
- OneDrive.
Source: Windows Central

Quick notation: If you desire to use an epitome from Bing, use the text box to search for a picture.
Select and insert the image.
(Optional) Click the Format Picture button from the left side if you need to adapt the size, rotation, or scale.

Source: Windows Central
Change the image settings as needed.

Source: Windows Central
Click the OK button.

After you consummate the steps, the paradigm volition appear in the location y'all specified.

While the ability to utilise a header and footer has been available for a long fourth dimension, if yous are even so using an older version of Office, you lot should consider upgrading to Role from Microsoft 365. The subscription-based service offers a gratuitous upgrade and other benefits, such as sharing the apps with up to 6 family members and friends. Yous also go admission to services like Microsoft Teams, Family Condom, Microsoft Editor, and 1TB of OneDrive storage.

Become subscribed

Microsoft 365

Microsoft 365 gives yous total access to all the Office apps and benefits like 1TB OneDrive storage and Skype minutes. You can also install Word, Excel, PowerPoint, Outlook, and other apps on up to 5 devices, and depending on the subscription, you lot can share the account with up to vi people.

How to add header and footer to all sheets in Excel

When working with a Microsoft Excel document, the header and footer will apply just to the current sheet, not the entire certificate. Withal, in that location's a manner to apply the same settings for all the sheets in the documents equally necessary.

To apply the aforementioned header and footer across sheets, use these steps:

Open Microsoft Excel.
Open the document you want to customize.
Add the header and footer as you usually would (see above steps).
Select the first canvas at the bottom of the document, hold on to the Ctrl key, and select the other sheets to which yous want to apply the same header.

Source: Windows Primal

Quick tip: If you lot want to select all the sheets, right-click one of the sheets, and choose the Select All Sheets pick.
Click the header of the sheet and click away.
Select the first canvass at the bottom of the document, agree on to the Ctrl key, and select the other sheets to which you want to utilize the aforementioned footer.
Click the footer of the sheet and click away.

One time you lot complete the steps, the configuration will replicate all the Excel sheets in the documents.

How to remove header and footer in Excel

If you take been tasked to edit and remove the header and footer from a document, you lot can complete this process in at least two ways.

From the Insert tab

To remove the footer and header from an Excel document with the Insert tab, utilize these steps:

Open Microsoft Excel.
Open the document you desire to customize.
Click the Insert tab.
In the "Text" settings, click the Header & Footer selection.

Source: Windows Primal
In the "Header & Footer" settings, click the Header button and select the none option.

Source: Windows Primal
In the "Text" settings, click the Header & Footer choice.
In the "Header & Footer" settings, click the Footer button and select the none pick.
Click the View tab.
In the "Workbook Views" settings, click the Normal push to exit the view.

Source: Windows Central

Afterward you consummate the steps, the footer and header will no longer exist in the Excel canvass.

From the Page Layouts tab

To delete the footer and header with the Page Layouts tab, use these steps:

Open up Microsoft Excel.
Open the document yous desire to customize.
Click the Folio Layout tab.
In the "Page Setup" settings, click the Dialog Box Launcher button on the right side.

Source: Windows Central
Click the Header/Footer tab.
Use the Header drop-downwardly card to select the none option.

Source: Windows Key
Use the Footer drib-downwards menu to select the none selection.
Click the OK button.

Once you complete the steps, the configuration volition be removed from the document.

More Windows 10 resource

For more helpful articles, coverage, and answers to mutual questions almost Windows 10, visit the following resources:

Windows 10 on Windows Fundamental — All yous need to know
Windows 10 help, tips, and tricks
Windows 10 forums on Windows Central

We may earn a commission for purchases using our links. Learn more.

Time to come plans for FFXIV

Post-launch roadmap for Final Fantasy XIV: Endwalker revealed

The latest Letter from the Producer livestream has just aired, and information technology comes with a plethora of news for Final Fantasy XIV. This includes plans for updating all the main scenario quest dungeons, improving the graphics, implementing new sidequests, and much more than.