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.