Office Settings & Configuration

How to Display One Excel Worksheet Across Two Monitors

John WilsonJohn Wilson Nov 2, 2026 869 views

Question details

The user wants to view a single large Excel spreadsheet across two monitors to maximize screen space while maintaining readability.

How to Display One Excel Worksheet Across Two Monitors
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.
Before you start

Ensure your dual monitors are correctly connected and your operating system display settings are configured to 'Extend these displays' rather than 'Duplicate'.

Solution 1Recommended

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.

1
Open a New Window

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.

2
Move to the Second Monitor

Click and drag the title bar of the newly opened Excel window to your second monitor, then maximize it to fill the screen.

3
Enable Side by Side View

On the View tab, select 'View Side by Side'. If prompted, select the original workbook window to pair them together.

4
Synchronize Scrolling (Optional)

If you want both windows to scroll up and down simultaneously, click 'Synchronous Scrolling' located right below the 'View Side by Side' button.

Use New Window to Span Worksheets Across Monitors
Data Synchronization: Because both windows are displaying the exact same file, any edits or formatting changes you make in one window will instantly reflect in the other.
Enhance Productivity with WPS Office

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. 1. Open Your Spreadsheet: Launch WPS Office and open your large data file in WPS Spreadsheet.
  2. 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. 3. Drag to Your Second Monitor: Click and drag the new window's title bar over to your second screen.
  4. 4. Maximize and Arrange: Maximize both windows on their respective monitors to enjoy a seamless, expansive workspace for your data.
Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Effortlessly span and duplicate document windows across dual monitor setups.Lightweight architecture ensures smooth scrolling even on massive datasets.Intuitive tabbed interface makes managing multiple workbooks straightforward.
microsoft office alternative - wps office

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.