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.
Step 3: Click the Header & Footer button in the Text section of the ribbon.
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.
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 –
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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
