How to add a header and footer in Excel

You can add a header and footer to Excel, and in this guide, we’ll show you how.

When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.

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 page number at the bottom to keep everything organized.

However, if you want to set up the spreadsheet, theMicrosoft 365 version of Office, Office 2019, and older versions includes multiple ways to add and change the header and footer of the page, and there is even a way to apply the same configuration other pages in the document without repeating the steps.

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

How to add header and footer in Excel

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

From the Insert tab

From the Insert tab

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

Once 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 (&), then you will need to use two ampersands (&&). If you need to exit the header or footer without applying changes, pressEsc. You can click anywhere in the document to exist and apply the changes.

Get the Windows Central Newsletter

All the latest news, reviews, and guides for Windows and Xbox diehards.

Use image for header or footer in Excel

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

After 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:

Once you complete the steps, the header and footer will be applied to the sheet you are editing. If you do not see the changes, click theViewtab, and then in the “Workbook Views” settings, click thePage Layoutbutton.

Use image for header or footer in Excel

To use the Page Layout tab to add an image for the header or footer, use these steps:

After you complete the steps, the image will appear in the location you specified.

While the ability to use a header and footer has been available for a long time, if you are still using an older version of Office, you should consider upgrading to Office from Microsoft 365. The subscription-based service offers a free upgrade and other benefits, such as sharing the apps with up to six family members and friends. You also get access to services like Microsoft Teams, Family Safety, Microsoft Editor, and 1TB of OneDrive storage.

Microsoft 365 gives you full 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 five devices, and depending on the subscription, you can share the account with up to six people.

When working with a Microsoft Excel document, the header and footer will apply only to the current sheet, not the entire document. However, there’s a way to use the same settings for all the sheets in the documents as necessary.

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

Once you complete the steps, the configuration will replicate all the Excel sheets in the documents.

If you have been tasked to edit and remove the header and footer from a document, you 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, use these steps:

After you complete the steps, the footer and header will no longer be in the Excel sheet.

From the Page Layouts tab

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

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

More Windows 10 resources

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

Mauro Huculak has been a Windows How-To Expert contributor for WindowsCentral.com for nearly a decade and has over 15 years of experience writing comprehensive guides. He also has an IT background and has achieved different professional certifications from Microsoft, Cisco, VMware, and CompTIA. He has been recognized as a Microsoft MVP for many years.