How to Find Split Screen in Excel
What Is Split Screen in Excel?
Use Excel’s split-screen feature to view multiple copies of the same worksheet. Splitting the screen divides the current worksheet vertically and/or horizontally into two or four sections allowing you to see the same or different areas of the worksheet. Splitting the screen is an alternative to freezing panes to keep worksheet titles or headings on screen as you scroll. In addition, split screens can be used to compare two rows or columns of data located in different parts of the worksheet.
Split the Screen Into Two or Four Panes
You can split the Excel screen into four panes using the Split icon located on the View tab of the ribbon. This option works by adding both horizontal and vertical split bars to the worksheet. Each pane contains a copy of the entire worksheet and the split bars can be manipulated individually or together to allow you to see various rows and columns of data at the same time.
Splitting the Screen Both Horizontally and Vertically
The steps below cover how to split the Excel screen both horizontally and vertically using the Split feature.
Adding the Data
Although data doesn’t need to be present for split screens to work, it makes it easier to understand how the feature works if a worksheet containing data is used.
Splitting the Screen in Four
Splitting the Screen in Two
To reduce the number of screens to two, drag one of the two split bars to the top or right side of the screen. For example, to have the screen split horizontally, drag the vertical split bar to the far right or far left of the worksheet, leaving only the horizontal bar to split the screen.
Removing Split Screens
To remove all split screens:
Click on View > Split to turn the split-screen feature off;
or
Drag both split bars to the edges of the screen; with both bars in this position, the split icon on the ribbon is turned off.
Split the Excel Screen With the Split Box
For those using Excel 2010, instructions for using the split box can be found below.
Split Screens With the Split Box in Excel 2010
As seen in the image above, you can split the Excel screen horizontally using the split box located at the top of the vertical scrollbar. The vertical split box is located in the bottom right corner of the Excel screen, between the vertical and horizontal scrollbars. Using the split box rather than the split option located under the View tab allows you to split the screen in one direction only – which is what most users want.
Splitting the Screen Horizontally
Removing Split Screens
You have two options for removing split screens:
