Insert and edit header and footer in Excel
What is very simple and self-evident in Word is unfortunately a Microsoft-made problem in Excel. It is about inserting and adjusting headers and footers in Excel. This is similar to moving pages in Word. In PowerPoint it is very easy to remove pages, and in other in-house software it is made complicated and can only be solved with workarounds. It also doesn’t matter whether you work with Office 365 or with Office 2019 or currently Office 2021. It’s the same problem everywhere.

This short article is only about how to insert and customize headers and footers in Excel. There are a few little pitfalls and limitations in Excel here and there, but I’ll try to give tips for them as best I can. And how it turns out good in the end.
Insert and edit header and footer in Excel
What is very simple and self-evident in Word is unfortunately a Microsoft-made problem in Excel. It is about inserting and adjusting headers and footers in Excel. This is similar to moving pages in Word. In PowerPoint it is very easy to remove pages, and in other in-house software it is made complicated and can only be solved with workarounds. It also doesn’t matter whether you work with Office 365 or with Office 2019 or currently Office 2021. It’s the same problem everywhere.

This short article is only about how to insert and customize headers and footers in Excel. There are a few little pitfalls and limitations in Excel here and there, but I’ll try to give tips for them as best I can. And how it turns out good in the end.
Insert and customize header in Excel
Insert and customize header in Excel
As usual, there are several ways of inserting headers in Excel. The first way is the easier one and is to go to the “Page Layout – Custom Margins” tab and then select the Header/Footer tab in the dialog box. Here you can not only define the layout settings with margins etc., but also adjust the headers and footers.
see fig. (click to enlarge)
Here you have the option of inserting common content such as the page number, date, document title, etc. for the header and footer. As in Word, you can also provide the first page with a different header than the following pages. Something like this is of course ideal for invoice documents, for example, where the company logo should only appear on the first but not on the following pages. I would keep the “Align to margin” and “Scale with document” checked so that the header and footer are flush with the rest of the content in the document.
If you select the custom header and footer options in the dialog box, you will quickly notice how limited Excel is in contrast to Word. The fact that you only have the option of jumping between three content windows to add content would be something you could live with, but that’s not all, unfortunately, the orientation of the content is also fixed. The content in the left content window is left-aligned, the text is centered in the middle window and right-aligned in the right window.
Unfortunately, this has always been the case, and Microsoft doesn’t bother with it either, because there is probably too little interest and pressure from users.
see fig. (click to enlarge)
By the way, it’s the same problem with both the header and the footer that you have to deal with here. In the case of the header, where perhaps there is only a logo, you can possibly get used to it, and since such an element is usually aligned to the right, left or center anyway. But that doesn’t work with the footer. At least not in the middle content section.
The only viable way I see at this point is to use the option that Excel also offers. You can also include graphics in the header and footer. I therefore recommend the following:
- Create a footer in Word of your choice.
- Take a screenshot (shortcut for Windows: Windows logo key + SHIFT + S) of the area that will later be used as a footer in Excel.
- Paste the graphic into the middle section with the center alignment.
You may have to adjust the page spacing and the print area a bit (easiest to check in the print preview in Excel) so that it looks good. But unfortunately you don’t have many more options in Excel. Another Wordaround would be to create a Word document with sensible headers and footers and then insert your Excel spreadsheet into Word.
By the way: At the beginning I wrote that there are several ways to get to the header and footer settings in Excel. I have already described the easy way. But for the sake of completeness I wanted to briefly describe the other way:
- Go to Header and Footer from the Insert tab
- At the top left (under File) you can then jump between the header and footer and insert content directly.
A small advantage of this way is that you get the header and footer displayed directly in the document, but the disadvantage is that many users often do not know how to get out of the view to continue working on the document. This only works via the “View” tab and then “Normal”. But I won’t go into it any further at this point, because I’m actually trying to explain things as simply as possible.
As usual, there are several ways of inserting headers in Excel. The first way is the easier one and is to go to the “Page Layout – Custom Margins” tab and then select the Header/Footer tab in the dialog box. Here you can not only define the layout settings with margins etc., but also adjust the headers and footers.
see fig. (click to enlarge)
Here you have the option of inserting common content such as the page number, date, document title, etc. for the header and footer. As in Word, you can also provide the first page with a different header than the following pages. Something like this is of course ideal for invoice documents, for example, where the company logo should only appear on the first but not on the following pages. I would keep the “Align to margin” and “Scale with document” checked so that the header and footer are flush with the rest of the content in the document.
If you select the custom header and footer options in the dialog box, you will quickly notice how limited Excel is in contrast to Word. The fact that you only have the option of jumping between three content windows to add content would be something you could live with, but that’s not all, unfortunately, the orientation of the content is also fixed. The content in the left content window is left-aligned, the text is centered in the middle window and right-aligned in the right window.
Unfortunately, this has always been the case, and Microsoft doesn’t bother with it either, because there is probably too little interest and pressure from users.
see fig. (click to enlarge)
By the way, it’s the same problem with both the header and the footer that you have to deal with here. In the case of the header, where perhaps there is only a logo, you can possibly get used to it, and since such an element is usually aligned to the right, left or center anyway. But that doesn’t work with the footer. At least not in the middle content section.
The only viable way I see at this point is to use the option that Excel also offers. You can also include graphics in the header and footer. I therefore recommend the following:
- Create a footer in Word of your choice.
- Take a screenshot (shortcut for Windows: Windows logo key + SHIFT + S) of the area that will later be used as a footer in Excel.
- Paste the graphic into the middle section with the center alignment.
You may have to adjust the page spacing and the print area a bit (easiest to check in the print preview in Excel) so that it looks good. But unfortunately you don’t have many more options in Excel. Another Wordaround would be to create a Word document with sensible headers and footers and then insert your Excel spreadsheet into Word.
By the way: At the beginning I wrote that there are several ways to get to the header and footer settings in Excel. I have already described the easy way. But for the sake of completeness I wanted to briefly describe the other way:
- Go to Header and Footer from the Insert tab
- At the top left (under File) you can then jump between the header and footer and insert content directly.
A small advantage of this way is that you get the header and footer displayed directly in the document, but the disadvantage is that many users often do not know how to get out of the view to continue working on the document. This only works via the “View” tab and then “Normal”. But I won’t go into it any further at this point, because I’m actually trying to explain things as simply as possible.
Popular Posts:
Header and footer in Word – First page different in Word
How to make headers different on the first page than on the rest of the pages. Also create custom footers in Word for your documents.
Clean up Excel spreadsheets
It is very easy to use Excel tables created without a system and still get usable data from them with a few tricks.
Insert and edit header and footer in Excel
Inserting a header and footer in Excel is far from user-friendly. We show ways and workarounds how you can do it anyway.
Concatenate text and date in Excel – Tutorial
Concatenating text and date in Excel requires a combination of two functions. We use a practical example to explain how it can be used.
Create and save your own text modules in Word
Create your own text blocks in Word, save them and quickly add ready-made text and graphics to your documents.
Data Queries in Excel – Works with Power Query
So erstellen Sie aktive Datenabfragen durch Power Query aus verschiedensten Quellen in Excel, führen Daten aus verschiedenen Dateien und Tabellen zusammen.
Popular Posts:
Header and footer in Word – First page different in Word
How to make headers different on the first page than on the rest of the pages. Also create custom footers in Word for your documents.
Clean up Excel spreadsheets
It is very easy to use Excel tables created without a system and still get usable data from them with a few tricks.
Insert and edit header and footer in Excel
Inserting a header and footer in Excel is far from user-friendly. We show ways and workarounds how you can do it anyway.
Concatenate text and date in Excel – Tutorial
Concatenating text and date in Excel requires a combination of two functions. We use a practical example to explain how it can be used.
Create and save your own text modules in Word
Create your own text blocks in Word, save them and quickly add ready-made text and graphics to your documents.
Data Queries in Excel – Works with Power Query
So erstellen Sie aktive Datenabfragen durch Power Query aus verschiedensten Quellen in Excel, führen Daten aus verschiedenen Dateien und Tabellen zusammen.