How to Fix Excel Arrange All Not Displaying Four Workbooks
Question details
The user needs to resolve an issue where Excel fails to tile all four open workbooks simultaneously and occasionally blocks the fourth workbook from opening.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to view multiple open workbooks side-by-side using the Arrange All tiled view.
- Observed behavior
- When selecting View > Arrange All > Tiled, Excel does not display all four open workbooks, and in some cases, the fourth workbook fails to open entirely.
Ensure all workbooks you intend to arrange are completely restored and not minimized to the taskbar. Minimized windows will not automatically tile when using the Arrange All command.
Verify Tiled View Settings
Ensure you are correctly applying the Tiled view without accidentally restricting it to a single active workbook.
Sometimes the 'Arrange All' feature is misconfigured to only sort windows from the current file, causing it to ignore other separate workbooks you have opened.
Launch Microsoft Excel and open all four workbooks you wish to display.
Navigate to the View tab located on the top Excel ribbon.
In the Window group, click on the Arrange All button.
Select the 'Tiled' option. Crucially, ensure that the checkbox for 'Windows of active workbook' is unchecked, then click OK.
Run an Online Repair for Microsoft Office
If Excel consistently fails to open the fourth workbook or fails to tile them properly, your Office installation might be corrupted and requires a repair.
Easily Manage Multiple Workbooks with WPS Office
If Microsoft Excel continues to crash or fails to tile your workbooks correctly, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool with native support for viewing multiple files seamlessly without the heavy system load.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website.
- 2. Open your workbooks: Launch WPS Spreadsheet and load all four of your Excel workbooks.
- 3. Tile your windows: Navigate to the View tab, click Arrange All, and select your preferred tiled layout to view them side-by-side immediately.
Frequently Asked Questions
Why is the Arrange All button grayed out in Excel?
The Arrange All button becomes temporarily disabled if you are actively editing a cell, a dialog box is open, or if the workbook is protected. Press Enter or Esc on your keyboard to finish editing the cell and try again.
What does 'Windows of active workbook' mean in the Arrange All menu?
Checking this option tells Excel to only tile multiple sheets or windows that belong to the currently active workbook. To tile completely different workbooks alongside each other, you must leave this box unchecked.
Can I arrange Excel workbooks across multiple monitors?
Yes, but Excel's internal Arrange All command only tiles windows within a single monitor's bounds. To span multiple monitors, manually drag each workbook to your preferred screen and use Windows snap features (Windows Key + Arrow keys) to organize them.
Why does a workbook disappear when I click Arrange All?
The workbook may be minimized to your taskbar or hidden from view. Check your taskbar to ensure all files are fully restored, or navigate to View > Unhide to verify the window wasn't accidentally hidden before arranging.
