You need to view different parts of the same Excel file at once. This is common when comparing data on separate sheets or checking formulas against their results. Excel’s View Side by Side feature only works with different files. This article explains how to open a single workbook in two separate application windows for true side-by-side comparison.
Key Takeaways: Open One File in Two Windows
- View > New Window: Creates a second window of the active workbook, allowing you to arrange them independently.
- Windows Snap Layouts (Windows 11): Lets you quickly arrange the two Excel windows side by side on your screen.
- View > Arrange All > Vertical: Tiles all open Excel windows vertically within the Excel application frame.
Understanding Excel’s Single-Instance Behavior
By default, Excel opens one workbook per application window. This design keeps your taskbar clean. However, it prevents you from viewing two sections of the same file simultaneously. The feature to open a new window for the active workbook exists within the View tab. It creates a second instance linked to the same file. Any change you make in one window appears instantly in the other. This is because both windows are editing the same underlying data file.
Steps to Open and Arrange Two Windows
Follow these steps to create a second window for your workbook and arrange it on your screen.
- Open your Excel workbook
Start Excel and open the file you want to view in two windows. - Create a new window
Go to the View tab on the ribbon. In the Window group, click the New Window button. Excel opens a second window for the same workbook. The title bar will show your filename followed by :1 and :2. - Arrange the windows manually
Click and drag the title bar of one window. Move it to the left or right side of your screen. In Windows 11, hover over the maximize button and select a snap layout. Drag the second window to the opposite side. - Navigate to different views
In the first window, scroll to the sheet or cell range you want to see. In the second window, navigate to a different sheet or a distant part of the same sheet. You can now compare them side by side. - Use Excel’s Arrange All feature
If you prefer, go to the View tab again. Click Arrange All in the Window group. Select Vertical to tile the two windows side-by-side within the Excel application frame.
Common Mistakes and Limitations
View Side by Side Button is Grayed Out
The View Side by Side button under View > Window requires two different workbooks. It will be inactive if you only have one file open, even in two windows. This feature synchronizes scrolling between two separate files. It is not the method for opening one file twice.
Changes in One Window Not Appearing in the Other
Both windows are linked to the same file. Edits should appear immediately. If they do not, you may have accidentally opened a copy of the file. Check the title bars. They should show the same filename with :1 and :2. If the names are different, you opened two separate files.
Cannot Open a Third Window
You can open more than two windows. Simply click View > New Window again. Each new click creates another window. Your system’s memory and performance are the only limits. Too many windows may slow down Excel.
Manual Arrangement vs. Arrange All: Key Differences
| Item | Manual Window Arrangement | Excel’s Arrange All Feature |
|---|---|---|
| Control | Full control over window size and screen position | Excel automatically tiles windows within its frame |
| Best For | Using Windows Snap layouts or multiple monitors | Quickly viewing all open workbook windows at once |
| Window Independence | Windows can be moved outside the Excel main window | Windows are contained within the parent Excel application |
| Method | Drag and drop or use Windows Snap Assist | View tab > Window group > Arrange All |
You can now compare data from different sheets or distant ranges in one file. Use the New Window command whenever you need a duplicate view. For advanced use, try opening the same workbook on two different monitors. Remember that closing any window does not save the file. You must save from one of the remaining open windows.