How to Split the Excel Window to View Two Sections of a Sheet at Once

You may need to compare data from different parts of a large worksheet without constantly scrolling. This is a common task for reviewing totals against details or checking formulas in separate areas. Excel’s Split feature creates independent panes within the same window. This article explains how to set up and use window splits to view two or four sections simultaneously.

Understanding the Excel Window Split Feature

The Split command divides the worksheet window into separate resizable panes. Each pane has its own scroll bars, allowing you to navigate different sections independently. This is different from freezing panes, which locks specific rows or columns in place while the rest of the sheet scrolls. A split is purely a viewing aid and does not affect printing or cell data. You can create two panes side-by-side, two panes stacked, or four quadrants.

The split bars are thick gray lines that you can drag to adjust pane sizes. You need at least a few rows and columns of data to make splitting useful. The feature works in all modern Excel versions on Windows and Mac, though the exact menu location may vary slightly. No special setup or add-ins are required.

Steps to Split the Excel Window

You can split the window using the ribbon menu, the mouse on the scroll bar, or a keyboard shortcut. The method you choose depends on whether you want a simple two-pane split or more precise control.

Method 1: Using the Ribbon Menu

1. Select your starting cell
   Click the cell where you want the split to originate. For a vertical split, select a cell in the top row. For a horizontal split, select a cell in column A. For four panes, select any cell not in the first row or column.
2. Open the Split command
   Go to the View tab on the ribbon. In the Window group, click the Split button. Excel will immediately insert split bars above and to the left of the active cell.
3. Adjust the split bars
   Move your mouse cursor over a split bar until it changes to a double-line resize pointer. Click and drag the bar to reposition it. You can drag a bar to the edge of the window to remove that specific split.

Method 2: Using the Split Boxes on the Scroll Bar

1. Locate the split boxes
   Look at the top of the vertical scroll bar. You will see a thin horizontal box. Look at the right end of the horizontal scroll bar for a thin vertical box.
2. Drag to create a split
   Click and drag the horizontal split box downward to create a two-pane horizontal split. Drag the vertical split box leftward to create a two-pane vertical split. This method gives you quick control over a single split line.

Method 3: Using the Keyboard Shortcut

1. Position the active cell
   Select the cell where you want the split to appear, following the same rules as the ribbon method.
2. Execute the shortcut
   Press Alt + W + S on your keyboard. This is the keyboard equivalent of clicking View > Window > Split. Press the same shortcut again to remove all splits.

Common Mistakes and Limitations

While the split feature is powerful, users often encounter a few specific issues. Understanding these will help you use the tool more effectively.

Split Bars Disappear or Don’t Work

If split bars are not visible, the window may already be in Page Break Preview or Custom View mode. Switch to Normal view via View > Workbook Views > Normal. Also, ensure you are not in cell edit mode by pressing Escape.

Cannot Scroll Panes Independently

All panes created by a single split bar are synchronized along that axis. For example, in a two-pane vertical split, scrolling up or down in one pane will scroll the other. Only panes separated by both a horizontal and vertical bar can scroll completely independently in all directions.

Split Feature Grayed Out in the Menu

The Split button may be disabled if the workbook is protected, if you are editing a cell, or if the sheet is in a shared workbook mode. Exit cell edit mode, remove workbook protection via Review > Protect Workbook, or turn off sharing temporarily.

Split vs Freeze Panes: Key Differences

Item	Split Panes	Freeze Panes
Primary Use	View separate, scrollable areas of the same sheet	Keep row/column headers visible while scrolling
Scroll Behavior	Each pane can scroll independently	Only the unfrozen area scrolls
Visual Marker	Thick, movable gray split bars	Thin solid lines
Removal Method	Double-click split bar or click Split button again	View > Window > Freeze Panes > Unfreeze Panes
Printing Effect	Does not affect printed output	Does not affect printed output

You can now view distant parts of your worksheet side-by-side without opening a second window. Try splitting the window and then freezing panes within one section for complex data analysis. For advanced navigation, use the F6 key to cycle the keyboard focus between each split pane.