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 –
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.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.