Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.