Split screen in Excel

Use Excel’s split screen feature to view multiple copies of the same sheet. Split Screen divides the current worksheet vertically and/or horizontally into two or four sections so that you can see the same or different parts of the worksheet.

Split screen is an alternative to freezing panes to keep headers or sheet titles on the screen as you scroll. In addition, split screens can be used to compare two rows or columns of data in different parts of a worksheet.

Content
  1. Find split screens
  2. Split the screen into two or four panels
  3. Split screen horizontally and vertically
  4. Add data
  5. Split screen into four
  6. Split screen in half
  7. Remove split screens
  8. Split Excel screen with splitbox
  9. Split screens with splitbox in Excel 2010
  10. Split screen horizontally
  11. Remove split screens

Find split screens

  1. Click on the tab Vision on the tape.

  2. Click the icon Distribution to split the screen into four parts.

These instructions apply to Excel 2019, 2016, 2013, and Excel for Office 365.

Split the screen into two or four panels

The Excel screen can be divided into four panels using the icon Distribution is on the tab Vision on the tape.

This option works by adding horizontal and vertical separator bars to the sheet.

Each pane contains a copy of the entire worksheet, and the split bars can be manipulated individually or together, allowing you to see several rows and columns of data at the same time.

Split screen horizontally and vertically

The steps below show you how to split the Excel screen horizontally and vertically using the split function.

Add data

While data does not need to be present for split screens to work, it becomes easier to understand how this feature works if a worksheet of data is used.

  1. Open a worksheet with a reasonable amount of data, or add multiple rows of data to the worksheet, like the data in the image above.

  2. Remember, you can use the fill handle to automatically fill in the days of the week and consecutive column headings, such as: example1, example2 and so on.

Split screen into four

  1. Click on the tab Vision on the tape.

  2. Click Distribution in the Window group to enable the split screen feature.

  3. Horizontal and vertical dividing lines should appear in the center of the sheet.

  4. Each of the four quadrants created by the separator bars must have a copy of the worksheet.

  5. There should also be two vertical scroll bars on the right side of the screen and two horizontal scroll bars on the bottom of the screen.

  6. Use the scroll bars to navigate in each quadrant.

  7. Rearrange the split bars by clicking and dragging them with the mouse.

Split screen in half

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 split the screen horizontally, drag the vertical split bar to the far right or far left of the sheet, leaving only the horizontal split bar.

Remove split screens

To remove all split screens:

  • Click Vision Distribution to disable the split screen function;

or

  • Drag both split bars to the edges of the screen; with both bars in this position, the split icon on the ribbon is disabled.

Split Excel screen with splitbox

The splitter, the second and very popular way to split the screen in Excel, has been removed by Microsoft since Excel 2013.

For those using Excel 2010, below are instructions on how to use a split window.

Split screens with splitbox in Excel 2010

As shown in the image above, you can split the Excel screen horizontally using the split box at the top of the vertical scroll bar.

The vertical separator is located in the lower-right corner of the Excel screen, between the vertical and horizontal scroll bars.

Using a split field instead of a parameter divide is on the tab Vision allows you to split the screen in only one direction – this is what most users need.

Split screen horizontally

  1. Hover over divided field above the vertical scroll bar, as shown in the image above.

  2. The mouse pointer changes to a double-headed black arrow when you are over the split box.

  3. When the mouse pointer changes, hold down the left mouse button.

  4. A dark horizontal line should appear above the first line of the worksheet.

  5. Drag the mouse pointer down.

  6. The dark horizontal line should follow the mouse pointer.

  7. When the mouse pointer is below the column header row on the worksheet, release the left mouse button.

  8. A horizontal separator bar should appear on the sheet where the mouse button was released.

  9. There should be two copies of the sheet above and below the separator bar.

  10. There should also be two vertical scroll bars on the right side of the screen.

  11. Use two scroll bars to arrange the data so that the column headings are visible above the separator bar and the rest of the data below.

  12. The split rod position can be changed as often as needed.

Remove split screens

You have two options to remove split screens:

  1. Press split window on the right side of the screen and drag it back to the top of the sheet.

  2. Click the icon Vision Distribution to disable the split screen function.

Leave a Reply

Your email address will not be published.