Excel Split Screen: How to View Multiple Worksheets at Once

Excel has a built-in split screen feature — View → New Window → Arrange All → Tile. It works. But it resets every time you close the file, clutters your taskbar with duplicate windows, and gets disorienting on large or ultrawide monitors. Here's exactly how to use it, when it breaks down, and what Excel power users do instead.

Why viewing multiple worksheets at once is harder than it sounds

Excel is built around one active sheet at a time. Tabs live at the bottom of the window, and switching between them is sequential — click one, lose sight of the other. For quick lookups this is fine. For any real cross-sheet work, it's a constant context-switch tax.

The workflows where this hurts most:

• Budget vs. actuals — comparing planned numbers to what actually happened, row by row
• Data entry from a reference sheet — copying values from one tab while filling in another
• Multi-tab audits — checking that summary totals match the source data on underlying sheets
• Client-facing vs. internal versions — keeping two versions of a report open side by side during a review call

In all these cases, the tab-switching rhythm kills your flow. You're constantly trying to hold one number in working memory while navigating to the other sheet to find its counterpart. It's mental overhead that adds up fast across a full workday.

The native approach: New Window + Arrange All

Excel's built-in answer to split screen is the New Window feature. Here's how to use it:

1. 1
   Open your workbook Make sure the file you want to view in split screen is open. You only need one copy of the file — Excel will create a second window view of it.
2. 2
   Create a new window: View → New Window This opens a second Excel window showing the same workbook. Notice the title bar now reads Book1.xlsx:1 and Book1.xlsx:2 — same file, two views.
3. 3
   Arrange the windows: View → Arrange All → Vertical (or Tiled) In either window, go to View → Arrange All. Select Vertical for side-by-side or Tiled for a 2×2 grid. Check Windows of active workbook to only tile your two views, not every open file.
4. 4
   Navigate each window to the sheet you want Click the left window and select your first tab. Click the right window and select your second tab. Both sheets are now visible simultaneously.
5. 5
   Optional: enable synchronized scrolling With both windows in view, go to View → Synchronous Scrolling to lock both panes to the same scroll position.

The keyboard shortcut approach

If you use the New Window method frequently, the menu navigation gets tedious. Excel has a keyboard shortcut to open a new window without touching the ribbon:

Press Alt W N to open the new window, then Alt W A to tile them. Once you've done it a few times, the whole sequence takes about five seconds.

On a Mac, the menu path is the same (View → New Window) but the keyboard shortcut differs. There's no consistent cross-platform shortcut — which is one of several reasons power users look for add-in based solutions.

Why the native split screen keeps failing you

The New Window approach works — once. The moment you close the file and reopen it, the layout is gone. Excel does not persist the split screen configuration. Every session starts fresh with a single window and all your tabs collapsed at the bottom.

Beyond the reset problem, there are three more friction points that compound over time:

1. Taskbar clutter

Each Excel window gets its own entry in the Windows taskbar. If you have three or four workbooks open and two of them have New Windows, your taskbar quickly becomes a row of indistinguishable Excel icons. Clicking the wrong one — or losing track of which :1 window had which tab — breaks the flow immediately.

2. Large and ultrawide monitors make it worse

On a 27-inch or ultrawide monitor, two tiled Excel windows each span roughly half the screen. With default zoom, your spreadsheet data occupies maybe 40% of each half-window — the rest is Excel chrome (ribbon, formula bar, status bar, row/column headers). You end up zooming in on both panes individually, which triggers its own scroll-sync issues.

3. You can only split same-file tabs

The Windows of active workbook checkbox in Arrange All only tiles windows from the current file. If you want to view a tab from Budget_2026.xlsx next to a tab from Actuals_Q1.xlsx, you need to manage two separate workbooks and arrange them manually — the checkbox won't help you there.

Native Excel split screen vs. DualPane

DualPane: split screen that remembers itself

DualPane is an Excel add-in that puts any two tabs — from the same workbook or different files — side by side inside a single Excel window. No second taskbar entry, no Arrange All ritual, no layout that disappears when you close the file.

How it works

After installing DualPane, a toolbar appears inside Excel. Select the left tab, select the right tab, click Split. Both sheets appear simultaneously in the same window, with the ribbon and status bar shared between them. On a standard 1920×1080 monitor, each pane gets a clean half of the usable screen area — no Excel chrome overhead on either side.

Saved layouts eliminate the setup ritual

The feature that actually changes the daily workflow: saved named layouts. If you view "Actuals" next to "Budget" every week, save that pair. The next time you open the workbook, one click loads both sheets in split view — no navigation, no Arrange All, no re-selecting tabs. The layout is stored in the workbook itself, so it travels with the file.

Synced scrolling that stays on

DualPane's synced scroll is a persistent toggle, not a fragile ribbon setting. Scroll one pane and the other follows. Resize either pane to give it more space. The sync stays active until you explicitly turn it off — no silent disabling on resize or window focus change.