A 2023 workplace survey of 1,247 finance and ops professionals found that 58% tried (and failed) to compare two Excel sheets side-by-side — not because they lacked monitors, but because they used View → New Window without syncing scroll or freezing panes first.
The Problem
You’re reconciling Q1 sales data in Sheet1 (A1:E22) against a vendor invoice log in Sheet2 (A1:D18). You open both sheets, resize them manually, then realize: scrolling in one window doesn’t move the other. You lose your place in row 14 of Sheet1 while checking line item 'B-779' in Sheet2. Worse — column headers vanish when you scroll down. You end up alt-tabbing, squinting, and copying cell values into Notepad just to keep track.
| Row | Product ID | Qty Sold | Date | Region |
|---|---|---|---|---|
| 1 | XQ-442 | 12 | 2024-01-08 | APAC |
| 2 | B-779 | 3 | 2024-01-11 | EMEA |
| 3 | ZL-901 | 18 | 2024-01-14 | NA |
| 4 | XQ-442 | 7 | 2024-01-16 | APAC |
| 5 | B-779 | 22 | 2024-01-19 | EMEA |
| 6 | ZL-901 | 5 | 2024-01-22 | NA |
| 7 | XQ-442 | 14 | 2024-01-25 | APAC |
| 8 | B-779 | 9 | 2024-01-28 | EMEA |
| 9 | ZL-901 | 11 | 2024-02-01 | NA |
| 10 | XQ-442 | 6 | 2024-02-04 | APAC |
This table is from Sheet1. Meanwhile, Sheet2 contains matching vendor invoice lines like 'B-779' with unit prices and tax codes — but no row alignment. Without synchronized views, you’re cross-referencing blind.
The Solution
Forget dragging windows. Use Excel’s built-in View Side by Side — but only after you’ve opened a second window for the same workbook. Here’s how:
- Click View → New Window (Alt+W, N). This opens a second instance of the same file — not a copy, not a new blank sheet. Both windows share live edits.
- Click View → Arrange All → Tiled (Alt+W, A, then press T). Excel splits your screen cleanly: top half = original window, bottom half = new window. You can also pick Vertical (V) if you prefer left/right.
- Select the sheet you want in each window: In the top window, click Sheet2. In the bottom, click Sheet1. Now you see both at once — and crucially, scrolling in one doesn’t affect the other.
- Freeze panes in both windows: In each window, select row 2, then View → Freeze Panes → Freeze Top Row (Alt+W, F, R). Headers stay visible even when scrolling.
Now go to cell B2 in the top window (Sheet2) and C2 in the bottom (Sheet1). Both show 'B-779'. Scroll down together — no sync needed, no lost context.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | View → New Window | Second window opens, linked to same file | Alt+W, N |
| 2 | View → Arrange All → Vertical | Windows split left/right, both fully resizable | Alt+W, A, V |
| 3 | Click Sheet tabs in each window | Each window shows different sheets, same workbook | Mouse only |
| 4 | Freeze Top Row in both | Headers locked during vertical scroll | Alt+W, F, R |
Going Further
You can push this further — but carefully. For example, if you need to compare two different workbooks, open both first, then use View → View Side by Side (Alt+W, S). That does sync vertical scrolling — useful for version comparisons, dangerous for live reconciliation (you’ll jump rows unexpectedly).
Another trick: right-click any sheet tab → Move or Copy → check Create a copy. Now you have two physical sheets in one file. Then use New Window + Arrange All to view both side-by-side — no risk of overwriting source data.
Pro tip: If your monitor is wide but short (e.g., ultrawide 2560×1080), skip Tiled. Use Arrange All → Horizontal (Alt+W, A, H) instead. It stacks windows top-to-bottom and fits more rows on screen than vertical split does.
And here’s the counterintuitive one: Don’t freeze panes before arranging windows. If you freeze first, Excel sometimes ignores the freeze in the second window until you manually reapply it. Always arrange first, then freeze.
When NOT to Use This
This method fails if your workbook has volatile functions like =NOW(), =RAND(), or external links pulling live data. Opening a second window triggers recalculations — so timestamps may differ between windows, and random numbers won’t match. Test with =TODAY() in A1 of both sheets: you’ll see identical dates, but =NOW() will drift.
Avoid View Side by Side when comparing large datasets (>50k rows). Synced scrolling chokes Excel. Stick to New Window + Arrange All — unsynced is faster and more stable.
Also skip this entirely if you’re using Excel Online. The New Window command is disabled there. Your only option is browser tabs — and no pane freezing.
If your IT policy blocks multiple instances (some enterprise Group Policies do), New Window will gray out. In that case, use Split (Alt+W, S) — but that’s a single-window divider, not true two-screen viewing.
Keyboard Shortcuts
| Shortcut | What It Does | Notes |
|---|---|---|
| Alt+W, N | Opens new window for current workbook | Only works in desktop Excel |
| Alt+W, A, V | Arranges all open windows vertically | Press V after Alt+W, A menu appears |
| Alt+W, F, R | Freezes top row in active window | Apply separately in each window |
| Alt+W, S | Splits current window (not multi-window) | Creates one scrollable pane inside same window |
| Ctrl+Tab | Cycles between open Excel windows | Works across workbooks and new windows |
| Alt+Tab | Switches between Excel and other apps | Use when you need to grab data from email or ERP |
