How to Make the Header Bigger in Excel 2010

Last updated on May 1st, 2023 at 11:49 am

Many people who need to create a document with a table will choose to use Microsoft Word. The reasoning is simple; if you have some data that belongs in a table and some data that doesn’t, it is simpler to insert a table in Word than it is to merge and resize cells in Excel. But you may encounter situations where someone has to have a file in Excel format, or you need to take advantage of some of the options that Excel offers which Word does not.

This is a time where the header in Microsoft Excel can come in handy, as you can enter information into the header without needing to worry about the restrictions of a spreadsheet. But if the default header space is not large enough, you can follow this tutorial to learn how to make it bigger.


Increase the Header Size in Excel 2010

While this function is useful, it does come with its’ drawbacks. First, you can only enter 255 characters into the header. Second, you will have limited formatting options for the text that you place into the header. So, with those caveats in mind, follow the steps outlined below to learn how to get a larger header in Excel 2010.


Step 1: Open the Excel spreadsheet that you need to modify.


Step 2: Click the Insert tab at the top of the window.

click the insert tab



Step 3: Click the Header & Footer button in the Text section of the ribbon.

make the header bigger in excel 2010



Step 4: Position your cursor at the left side of the screen, at the bottom of the top margin. The image below shows you what it should look like.

position your cursor at the bottom of the top margin



Step 5: When your cursor switches to the form shown in the image above, click your mouse and drag the margin down. This will change your spreadsheet so that it looks like this –

drag the bottom margin to the desired size



The logic behind making the header larger in this fashion is that it will prevent the header from overlapping the data contained within the cells.

If you want to return to the regular Excel view, you can follow the steps in this article.


If you’re shopping for a gift, or if you simply want a fun new gadget for your home, check out the Roku 3. It’s affordable, and offers the simplest possible way of accessing streaming video content from over 700 channels.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides