How to Use Split Screen in Excel Worksheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on February 17, 2023

This tutorial demonstrates how to use split screen in Excel.

 

screen split excel

 

Split Screen

The split screen option in Excel is useful when you have a large set of data you want to scroll through horizontally or vertically. In that case, Excel allows you to split the screen into four parts (panes) and scroll each pane independently. Every part of the screen displays the same data, but you can scroll each pane individually. This enables you to, for example, scroll in the first screen Rows 1–20, and on the second screen Rows 20–40, etc. Say you have the following data about products in Columns B and C, through Row 40.

 

split screens initial data

 

To split the screen, first decide where you want the split. Then, select the cell at the position where you want to split the screen horizontally and vertically (for example B17) and in the Ribbon, go to View > Split. (The shortcut for this action is ALT > W > S.)

 

split screen excel 1a

 

Now, the screen is split into four panes that can be scrolled independently.

 

screen split excel

 

When the screen split is active, columns left from the split point and rows above it are always fixed. In this case, the fixed part is Column B in the left pane and Rows 1–16 in the upper pane. Basically, with the screen split, you have the same data displayed in four panes of the window. If you select for example cell B2 and scroll the bottom screen up, you can see that B2 is selected on all four screen panes.

 

split screen scroll

 

This Excel feature is useful when you have large sets of data 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.

See also: How to Hide Vertical and Horizontal Scroll Bars in Excel and Compare Two Columns and Highlight Differences in Excel and Google Sheets

AI Formula Generator

Try for Free

See all How-To Articles