Arrange Excel Windows: Tile, Snap & Compare Fast
What You'll Be Able to Do (and Why Arranging Excel Windows Is More Useful Than It Looks)
Most Excel users lose more time to messy screens than to any formula problem they'll ever face. If you've spent the last few minutes dragging workbook windows around, resizing them by hand, and still ending up with one file half-buried behind another, there's a two-click fix you haven't used yet. Learning to properly arrange Excel windows changes how you work with multiple files: side-by-side data comparison, financial modeling across two workbooks, cross-referencing a data source while updating a report. It's one of those invisible efficiency gaps that nobody talks about because it doesn't look like a skill.
One thing that trips people up: starting with Excel 2013, Microsoft switched from a Multiple-Document Interface (MDI), where all workbooks lived inside one Excel window, to a Single-Document Interface (SDI), where each workbook opens in its own separate window. That's why some older instructions don't quite match what you're seeing. Everything below is tested in Excel 2016, 2019, and Microsoft 365, so you're covered regardless of which version you're on.
Before you start, you'll need at least two workbooks open. If you're working with two sheets inside the same file, I'll cover that case specifically in Step 1, since it requires one extra move most people don't know about.
|
| A tiled arrangement gives each workbook equal screen space, useful when you're comparing more than two files at once. |
Step 1: Open Multiple Excel Windows and Pick the Right Arrangement for Your Task
If you want to view two sheets from the same workbook side by side, you can't just hit Arrange All. You first need to create a second window for that file. Go to the View tab and click New Window. Excel opens a duplicate view of the same workbook (you'll see ":1" and ":2" appended to the title bar). Now both windows can be arranged independently, and changes made in one are reflected in the other in real time. This is the feature I see skipped in almost every tutorial on this topic, and it's genuinely useful, especially if you're working in a file that someone handed you with 87 unnamed sheets.
Once your windows are open, you're ready to choose an arrangement. Head to View > Arrange All in the Window group. The dialog gives you four options, and they're not interchangeable.
Tiled vs. Vertical vs. Horizontal vs. Cascade: Which One Actually Fits Your Work
Tiled splits the screen into equal quadrants, best for general comparison when you have two to four workbooks open and no strong preference for rows vs. columns. Vertical places windows in side-by-side columns, which is what you want when you're working with column-heavy data and need both files at full height. Horizontal stacks them top-to-bottom, which suits row scanning. Think comparing two versions of a report where you're reading left to right. Cascade overlaps windows in a diagonal stack, which is less useful for comparison but handy when you've got five or six workbooks open and you want quick access to each without losing your place.
For most comparison tasks, vertical is the right call. It's what I default to on my 27-inch external monitor when I'm cross-referencing a data source against an ops dashboard.
Step 2: Arrange Excel Windows Using the Ribbon, Keyboard Shortcuts, or Windows Snap
Now that your windows are open and you know which layout you want, here's how to get there without spending ten seconds hunting through menus every time.
The ribbon path is View tab > Window group > Arrange All. That works. But the faster route is the keyboard shortcut Alt+W+A. Press Alt, then W, then A in sequence (not simultaneously). The Arrange All dialog opens immediately. Pick your layout, hit Enter. Done.
Using Alt+W+A and Windows Snap Keys to Skip the Ribbon Entirely
If you're on Windows 10 or 11, you've got another option that bypasses Excel's dialog entirely: Windows snap. Hold the Windows key and tap the left or right arrow to snap the active Excel window to half the screen, then select the second workbook to fill the other half. It's faster for two-window setups, and Windows remembers each workbook's monitor position between sessions, which is genuinely useful if you're running a multi-monitor workflow where one file always lives on your secondary display.
For anyone working across two monitors in 2026, the snap approach is honestly faster than Arrange All for daily use. I still reach for Alt+W+A when I need to tile three or four files at once.
Step 3: Use View Side by Side with Synchronous Scrolling for Direct Comparison
Once you've arranged your windows, you might notice that View Side by Side exists as a separate option on the View tab, and it's not the same thing as Arrange All. This distinction matters.
View Side by Side is a two-window comparison tool. It places exactly two workbooks next to each other and enables Synchronous Scrolling, which locks both windows so they scroll together row by row. That's what makes it useful for comparing two versions of a dataset. You're not just looking at them next to each other, you're moving through them in lockstep. Arrange All doesn't do this.
If your sheets fall out of sync (which happens if you scroll one window independently before enabling the feature), click Reset Window Position on the View tab to re-align them. It's a small button that's easy to miss, but it solves the problem immediately. You can read more about working with Excel's View tab display options to get the most out of the window tools available there.
Common Mistakes When Arranging Excel Windows (and How to Fix Them Fast)
The most common problem: Arrange All is grayed out. This almost always means you only have one workbook open, not two separate files. Remember, Excel's single-document interface (SDI) treats each workbook as its own window, so Arrange All only activates when there's more than one to arrange. Open a second workbook, or use View > New Window first if you're working within the same file.
Watch out for the "Windows of active workbook" checkbox in the Arrange All dialog. If you check that box, Excel only arranges the windows belonging to your current file. Everything else disappears from view. Easy to do by accident, confusing to diagnose. Uncheck it to see all open workbooks again.
Windows snap problems across monitors are usually a display scaling issue. If a snapped window looks wrong or won't fill the expected half of a monitor, check that both displays are set to the same DPI scaling in Windows display settings.
If you're still getting oriented with how Excel's interface is organized, the Excel interface and navigation guide is a good place to fill in any gaps. And if you're relatively new to the application, the Excel for beginners starter guide covers the foundational context that makes features like this click faster.
Frequently Asked Questions
Why is the Arrange All button grayed out in Excel?
Arrange All requires at least two workbook windows to be open. In Excel 2013 and later (which uses a single-document interface), each file is its own window, so if you only have one file open, the button is unavailable. Open a second workbook, or go to View > New Window to create a second view of the same file.
What's the difference between tiled and vertical arrangement in Excel?
Tiled divides the screen into equal blocks, useful when you have more than two workbooks open. Vertical places windows in side-by-side columns at full height, which works better for column-heavy data where you need to see as many rows as possible in each file.
How do I view two sheets from the same workbook side by side?
Go to View > New Window to open a second instance of the same file. Then use View > Arrange All (or Alt+W+A) to tile or split them. Both windows show the same workbook, so you can navigate to different sheets in each one independently.
Join the conversation