Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Split Screen – Excelchat

Excel allows us to split the worksheet into panes so that we can scroll through each pane separately.  This is especially useful when we are working with a large data set and we want a split view of the screen.  

How to split screen

The method to split screen is very easy.  We only need to click on the cell where we want to split, like E6.  Then we click the View tab > Split button.

Figure 1.  Final result:  How to split screen

The screen will automatically be divided into four areas, with a horizontal and vertical line that serve as dividers, intersecting at the upper left corner of cell E6.  

We can now scroll down the bottom part of the worksheet while leaving the top portion stationary.  

Figure 2.  Scrolling the bottom part

Alternatively, we can also scroll down the upper portion of the worksheet and the bottom part will display the view exactly as we left it.  

Figure 3.  Scrolling the top part

In the same manner, we can also scroll the right side of the screen without changing the left side view, and vice versa.  

Figure 4.  Scrolling to the side

Move the split screen

We can actually move the split screen by simply dragging the lines up, down, left or right.  In the example below, we have moved the horizontal line below row 2, and the vertical line to the right of column C.  

Figure 5.  Output: Move the split screen

Horizontal split screen

We can also customize the split screen to show only two panes.  In order to split horizontally, follow these steps:

  • Click below the row where we want the screen to split.  We want the screen to split after the third row so we select row 4.  
  • Click View tab > Split

Figure 6.  Output: Horizontal split screen

The screen will split above the selected cells.  We can now scroll in the top and bottom screens separately.  

Figure 7.  Scrolling the bottom screen

Vertical split screen

Remember that the screen will split above and to the left of the active cells.  In order to split vertically, follow these steps:

  • Click column C
  • Click View tab > Split

Figure 8.  Output: Vertical split screen

The screen is split vertically and we can now scroll the left and right screens independently.  

Figure 9.  Scrolling the right screen

Remove split screen

To remove the split screen, simply uncheck the Split command button in View tab.

Figure 10.  How to remove split screen

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc