Office Settings & Configuration

How to Fix Excel Worksheet Split Across Two Monitors

Kushani NimanthikaKushani Nimanthika Nov 3, 2026 869 views

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.

How to Fix an Excel Worksheet Split Across Two Monitors
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.
Before you start

Ensure your secondary monitor is securely connected, powered on, and correctly configured to 'Extend' rather than 'Duplicate' in your computer's display settings.

Solution 1Recommended

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.

1
Check for Multiple Windows

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.

2
Close Extra Windows

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.

3
Maximize the Primary Window

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.

Save Changes: Closing a secondary view of a workbook does not delete your data; it simply closes that specific viewport. Always save your workbook after adjusting your window layout.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free installation package.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to enjoy a flawless multi-monitor viewing experience.
Free to use with a lightweight, fast installationFully compatible with Microsoft Excel (.xlsx, .xls) formatsFamiliar user interface requiring zero learning curveStable and reliable multi-monitor display capabilities
microsoft office alternative - wps office

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.