How to Display One Excel Worksheet Across Two Monitors
Question details
The user wants to view a single large Excel spreadsheet across two monitors to maximize screen space while maintaining readability.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Working with large datasets that require dual monitor setups for better visibility.
- Observed behavior
- Needs to span the view of a single worksheet across multiple screens without minimizing the zoom level to an unreadable size.
Ensure your dual monitors are correctly connected and your operating system display settings are configured to 'Extend these displays' rather than 'Duplicate'.
Use New Window to Span Worksheets Across Monitors
This method creates a secondary view of your active workbook, allowing you to drag the second window to another monitor.
Instead of stretching a single application window across two screens—which can cause monitor bezels to block your data—Excel provides a built-in feature to open multiple instances of the same workbook.
Open your spreadsheet in Excel. Go to the 'View' tab on the top ribbon menu and click 'New Window'. This opens a second view of your current workbook.
Click and drag the title bar of the newly opened Excel window to your second monitor, then maximize it to fill the screen.
On the View tab, select 'View Side by Side'. If prompted, select the original workbook window to pair them together.
If you want both windows to scroll up and down simultaneously, click 'Synchronous Scrolling' located right below the 'View Side by Side' button.

Easily Manage Large Spreadsheets on Multiple Monitors in WPS Office
WPS Spreadsheet provides a lightweight and highly compatible environment to handle massive datasets. You can seamlessly span your worksheets across multiple monitors using multi-window features to boost your multitasking efficiency.
- 1. Open Your Spreadsheet: Launch WPS Office and open your large data file in WPS Spreadsheet.
- 2. Create a New Window: Navigate to the 'View' tab on the ribbon and click on 'New Window' to duplicate the current document's view.
- 3. Drag to Your Second Monitor: Click and drag the new window's title bar over to your second screen.
- 4. Maximize and Arrange: Maximize both windows on their respective monitors to enjoy a seamless, expansive workspace for your data.

Frequently Asked Questions
Can I stretch a single Excel window across two monitors without opening a new window?
Yes, if Excel is not maximized, you can manually click and drag the edges of the application window across both screens. However, using the 'New Window' feature is generally recommended as it prevents monitor bezels from cutting off your data cells.
Will edits made in the second window be saved to the original file?
Yes. Both windows represent the exact same active file. Any changes made in either window are applied to the same document and will be saved together when you click Save.
Why is the 'Synchronous Scrolling' button greyed out?
Synchronous Scrolling only becomes available after you have activated the 'View Side by Side' feature. Ensure you have two windows open and Side by Side is enabled first before attempting to sync your scrolling.




