How to Add a Header and Footer in Excel

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Adding a header and footer in Excel is a mystery to some users.

Actually, some don’t even know that you can add a header and footer on an Excel document. (Don’t be surprised. A lot of people only see Excel as spreadsheet software and nothing more.)

In truth, it’s very easy to do so.

In this article, we’ll show you how to add a header and a footer to your Excel spreadsheet.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get started!

*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.

How to insert a header in Excel

Inserting a header in Excel is simple.

First, go to the ‘Insert’ tab on the tab list.

insert option on the tab list

Then, click the ‘Header & Footer’ icon found on the ‘Text’ group on the Ribbon.

header and footer icon under text group on the ribbon

The workbook view will now change to the ‘Page Layout’ view.

By default, the cursor is on the center section of the header. But if you would like to write a header on either left or right section, just click on them.

Kasper Langmann, Co-founder of Spreadsheeto
the center section of the header

Header & Footer Elements

As you’ve noticed, there are preset elements you can use on your header and/or footer.

Here’s a list of the elements you can insert:

  • Page number
  • Number of pages
  • Current date
  • Current time
  • File path
  • File name
  • Sheet name
  • Picture
the header and footer elements group on the ribbon

To use one, all you have to do is click its icon.

For example, you would like to insert page numbers on your sheets.

To do that, click the ‘Page Number’ icon on the ‘Header & Footer Elements’ group.

page number icon under the header and footer elements group on the ribbon

After that, a “&[Page]” will appear on the section of the header or footer.

page number code on the center section of the header

If you would like to see how it looks, simply click on anywhere on your sheet that’s not on the header or footer.

Take note that you have to have some content on your sheet before some of the header-footer elements are displayed.

Kasper Langmann, Co-founder of Spreadsheeto

You can also click on the ‘Header’ or ‘Footer’ icons on the left side of the ‘Design’ tab to see some of the preset headers and footers.

Once you click on the icons, you’ll see a list of headers/footers you can insert.

available preset footers on excel

Formatting the header/footer

It’s possible to format your header/footer especially the font size, color, and style.

This is also an alternate way to insert a header or footer.

Kasper Langmann, Co-founder of Spreadsheeto

To start, go the ‘Page Layout’ tab from the tab list.

page layout tab from the tab list

Then, click the page setup dialogue launcher found on the bottom-right corner of the ‘Page Setup’ group.

On the window, click the ‘Header/Footer’ tab.

Then, click the appropriate boxes whether you want to format the header or the footer.

Some of the buttons are familiar since they represent header and footer elements.

Let’s say you would like to change the font, font style, and font size, click the font icon on the window.

You’ll then see another window open where you can change the font of your header/footer.

changing header and footer font

Wrapping things up…

Headers and footers are a staple function if you’re working on a multiple-paged article, newsletter, and worksheets.

If you’re confused along the way, just fire up your Excel and try to follow this guide step-by-step.

Kasper Langmann, Co-founder of Spreadsheeto
2019-10-01T15:43:59+00:00