PlayInfoBox

Home /Utilities /How to Split the Excel Window to View Two Areas at Once

How to Split the Excel Window to View Two Areas at Once

Tap through each step in order.

  1. Click the cell where you want the split

    Click the cell that marks where you want the window divided.

  2. Open the View tab and click Split

    On the ribbon, open the "View" tab and click "Split" in the Window group.

  3. Confirm the window is now divided

    The window splits into separate panes around your chosen cell, and each pane can be scrolled independently.

  4. Scroll each pane to compare data

    Scroll one pane to the top of the sheet and another to the bottom to compare distant rows or columns at the same time.

  5. Why it is worth using

    When you need to compare a row near the top of a long sheet with one near the bottom, splitting the window lets you see both without constantly scrolling back and forth.

Tired of scrolling up and down to compare rows?

In a long sheet, checking a total near the bottom against source data near the top usually means scrolling back and forth repeatedly. Splitting the window divides the screen into independently scrollable panes, so both areas stay visible at once.

Resize or remove the split by dragging or double-clicking

Once the window is split, you can drag the split bar to make one pane larger than the other, or simply double-click the split bar to remove it and return to a single scrolling area β€” no need to reopen the View tab just to undo it.

Frequently Asked Questions

How is Split different from Freeze Panes?

Freeze Panes locks a specific row or column so it always stays visible while you scroll, while Split divides the window into separate panes that can each be scrolled freely in any direction.

How do I merge the split panes back into one?

Click "Split" again on the View tab, or drag the split bar all the way to the edge of the window, and the panes combine back into a single view.