Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to create a table in the header of Excel 2010?

share|improve this question
I don't think so. If I recall correctly, the UI for headers and footers is very basic, only allowing one line of text. – user3463 Aug 13 '12 at 8:47

No you can't do that I'm afraid.

However, you can simulate it to a certain degree. You have three areas to work with (left middle right) and you can have multiple lines though you may need to adjust the margins to fit.

Unfortunately, you will not be able to have borders.

If you need more than this. I would recommend not using the headers but instead simply have a table at the top of your spreadsheet that you make repeat on each page. That way you can have pretty much anything. If you need a table that doesn't match the table layout of the remainder of the spreadsheet, just do the header table in PowerPoint or Word and copy/paste it into place.

share|improve this answer

There is a pretty good solution.

What I did do was creating the rows I want in the header at the top of the cells. Print screen and adjust the image and save it somewhere on your desktop. Then go your header and add the image you just made (inside the first header). Because this is not a perfect solution - but very close - you need to adjust the column width of some of the columns.

Now you can delete the rows you'd made in the first place at the top of the cells. And as you can see the image appears in your header on every page.

Grt, Gerben

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.