How to Remove a Split Screen in Excel 2010

There are a lot of ways to customize the appearance of a worksheet in Excel 2010, and many of them are more useful to some people than others. For example, there are several different worksheet views that can be used, some of which are more helpful in certain situations than others. You can return to normal view if that is the view you prefer, which is just one way to begin restoring a heavily edited spreadsheet to the default view settings. But there is another option that splits the screen, keeping a set group of rows at the top of the window as you scroll to the bottom. While this can be beneficial in certain situations, it can be annoying if you aren’t used to it. Fortunately it is a simple process to disable the split and view the spreadsheet as you normally would.


Stop Splitting the Screen in Excel 2010

The split screen that I am referring to in this article looks like the image below –

example of excel 2010 split screen



As you can see, there is a horizontal bar that separates the rows that I have locked in the window, while the remainder of the rows scroll normally below the split. So continue reading below to learn how to remove this split screen on your Excel 2010 spreadsheet.


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


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

click the excel 2010 view tab



Step 3: Click the Split button to remove the split screen. Note that the button will be highlighted in orange before you click it, then will not be highlighted after you click it.

remove a split screen in excel 2010



If you are having difficulty printing in Excel, specifically fitting large spreadsheets onto fewer sheets of paper, then check out this article about fitting a spreadsheet on one page.

Join Our Free Newsletter

Featured guides and deals

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

Newest Guides