How to Fix Excel Worksheet Split Across Two Monitors
Question details
The user's Excel worksheet is displaying across two monitors, remaining partially visible and editable on the second screen even when the main window is maximized on one display.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working with an Excel workbook on a dual-monitor setup.
- Observed behavior
- The Excel worksheet is split across two screens, and using the 'Gather Windows' view feature does not correct the multi-monitor layout.
Ensure your secondary monitor is securely connected, powered on, and correctly configured to 'Extend' rather than 'Duplicate' in your computer's display settings.
Close Duplicate Workbook Windows
Multiple instances of the same workbook can cause the file to span across monitors. Closing extra windows resolves this display overlap.
This issue often occurs when the 'New Window' feature has been accidentally used, creating multiple views of the same workbook that span across your connected displays.
Look at the Excel title bar at the top of the screen. If you see a number after the file name (e.g., 'Budget.xlsx:1' and 'Budget.xlsx:2'), you have multiple windows open for the same file.
Click the 'X' in the top right corner of the secondary window (e.g., 'Budget.xlsx:2') located on your second monitor to close the duplicate view.
Drag the remaining primary Excel window to your main monitor and click the Maximize icon (the square) in the top right corner to snap it correctly to a single screen.
Update Microsoft Office and Display Drivers
Outdated software or graphics drivers can cause window scaling and positioning bugs in multi-monitor setups.
Perform an Office Online Repair
If standard troubleshooting fails, running a repair on your Office installation can fix corrupted files causing layout bugs.
Experience Seamless Multi-Monitor Support with WPS Office
If Microsoft Excel continues to struggle with layout glitches on your dual-monitor setup, try WPS Office. It is a highly compatible, free alternative that handles complex multi-screen environments effortlessly without splitting your workspaces.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to enjoy a flawless multi-monitor viewing experience.

Frequently Asked Questions
Why does my Excel window span across both monitors?
This usually happens if the Excel window is manually stretched instead of being fully maximized, or if multiple instances of the same workbook were created using the 'New Window' feature and dragged onto different screens.
How do I gather all Excel windows onto one screen?
You can try using the 'Arrange All' feature under the View tab. However, if you have duplicate views of the same workbook open, the best method is to manually close the extra windows and maximize the primary one.
Will running an Office repair delete my Excel files?
No, running an Office Online Repair only fixes the application's core files, layout settings, and registry keys. Your personal workbooks and data will remain completely intact.
How do I correctly maximize Excel on a single monitor?
Click and drag the title bar of the Excel window to the center of your desired monitor, then click the Maximize square icon located in the top right corner of the window. Alternatively, you can drag the window to the very top edge of the screen to snap it to full size.




