Table of Contents
This tip is about the how to Use Split Screen with Microsoft Excel. So read this free guide, How to Use Split Screen with Microsoft Excel step by step. If you have query related to same article you may contact us.
How to Use Split Screen with Microsoft Excel – Guide
Use Excel split screen feature to see multiple copies of the same worksheet. Split Screen splits the current sheet vertically and/or horizontally into two or four sections so you can see the same or different areas of the sheet. Splitting the screen is an alternative to freezing areas to keep sheet titles or headers on the screen as you scroll. Split screens can also be used to compare two rows or columns of data that are in different parts of the spreadsheet. You can use so-called “split screens” to display two different parts of the same spreadsheet at the same time.
You can divide your screen into two or four separate sections. This allows you to view different parts of a spreadsheet at the same time. Windows can be split horizontally or vertically. This can be done by selecting (Window > Split). The division takes place in the upper left corner of the active cell. You can only use split screen to view two parts of the same spreadsheet. You cannot use it to view two different sheets or workbooks. This is very different from freezing windows.
split screen
The split screen option in Excel is useful when you have a large set of data that you need to scroll horizontally or vertically. In this case, Excel allows you to split the screen into four parts (panels) and scroll each panel independently. Each part of the screen displays the same data, but you can scroll each panel individually. This allows, for example, scrolling in the first screen Lines 1–20 and in the second screen Lines 20–40 etc. Let’s say you have the following product data in Columns B and C, up to Row 40.
To split the screen, first decide where you want to split. So select the cell where you want to split the screen horizontally and vertically (eg B17) and on the Ribbon, go to View > Split. The screen is now divided into four panels that can be scrolled independently.
When screen split is enabled, columns to the left of and above the split point will always be fixed. In this case, the fixed part is Column B in the left panel and Rows 1–16 in the top panel. Basically, with screen splitting, you have the same data displayed in four window panes. If you select, for example, cell B2 and scroll down to the bottom screen up, you will see that B2 is selected in all four canvas panels.
This Excel feature it’s useful when you have large data sets to compare. Then you can split the screen and have one part of the data fixed while scrolling the other part. To turn off the split screen option, go back to View > Split.
screen split vertically
When you split your window vertically, you get two horizontal scroll bars. Select the column you want to split to appear on the left and select (Window > Split).
horizontally split screen
When you split your window horizontally, you get two vertical scrollbars. Select the line you want the split to be above and select (Window > Split).
Final note
I hope you like the guide How to Use Split Screen with Microsoft Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.