Office Settings & Configuration

How to Control the Position and Size of New Excel Windows

Olivia Miller Oct 22, 2026 869 views

Question details

The user wants to find a way to dictate the specific screen location and dimensions of newly opened Excel workbooks, preventing them from opening on the wrong monitor or behind active windows.

How to Control the Position and Size of New Excel Windows

Product: Microsoft Excel
Device & OS: Windows
Scenario: Opening and organizing multiple Excel workbooks simultaneously in a multi-monitor display setup.
Observed behavior: New workbooks open inconsistently across displays because Excel lacks a built-in standard setting to lock window position and size for new files.

Before you start

Ensure your multiple monitors are properly aligned in your Windows Display Settings so that windows do not accidentally launch into invisible off-screen areas.

Solution 1Recommended

Use Excel's Built-in 'Arrange All' Command

Quickly organize and position all currently open Excel workbooks on your active screen using the native view tools.

While Excel does not automatically force new windows into fixed coordinates upon launching, you can instantly organize all open files into a clean layout without dragging them manually.

Open all necessary workbooks

Launch Microsoft Excel and open the multiple workbook files you need to view and compare.

Navigate to the View tab

Click on the 'View' tab located in the top ribbon menu of the active Excel window.

Select Arrange All

In the Window group, click the 'Arrange All' button. Choose your preferred layout (Tiled, Horizontal, Vertical, or Cascade) from the dialog box and click 'OK'.

Use Excel's Built-in 'Arrange All' Command

Behavior Limitation: The Arrange All feature organizes currently open windows but will not save these positions as default rules for future workbooks you open.

Solution 2

Utilize Windows Snap Assist

Use the native Windows Snap Assist feature to quickly lock Excel windows to specific halves or quadrants of your monitors.

Solution 3

Apply Third-Party Window Management Utilities

For strict, automatic positioning rules every time you open a file, use dedicated window management software.

Free Microsoft Office alternative

Manage Multiple Spreadsheets Easily with WPS Office Tabs

Tired of losing Excel windows across multiple monitors? WPS Office is a free, lightweight alternative that uses a highly efficient tabbed interface by default. All your spreadsheets stay neatly organized in a single window, making multitasking seamless while ensuring full compatibility with Microsoft Excel formats.

1. Install WPS Office: Download and install the free WPS Office suite from the official website.
2. Open spreadsheets in tabs: Launch WPS Spreadsheets. As you open multiple files, they automatically populate as convenient tabs at the top of a single window, rather than scattered across screens.
3. Customize your view: Drag any tab outward to split it into a new window for a second monitor, or drag it back to merge it into your main workspace.

Tabbed workspace keeps multiple spreadsheets neatly organized in one unified window.Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Lightweight software architecture with fast startup times and low system resource usage.Drag and drop spreadsheet tabs to easily pull them into separate windows for multi-monitor setups.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel files keep opening on the wrong monitor?

Excel relies on the Windows operating system to handle window placement. Windows typically defaults to opening applications on the primary monitor or recalling the location where the application was last closed. Excel does not have an internal setting to force a designated monitor for new files.

Can I make Excel remember my exact window size and position?

Yes, for the standard view. Close all open Excel windows first. Open a single blank workbook, drag it to your preferred monitor, and resize it manually (do not maximize). Close that single workbook. The next time you open Excel, it should inherit those exact dimensions and placement.

How do I split two Excel sheets side-by-side on one screen?

Open both workbooks, navigate to the View tab in the ribbon, and click 'View Side by Side'. Alternatively, drag one window to the far left of your screen and the other to the far right using the Windows Snap feature.

Is there a way to open Excel workbooks in tabs instead of new windows?

Microsoft Excel does not natively support a tabbed interface. If you prefer working with browser-like tabs to avoid window clutter across monitors, consider using a free alternative like WPS Office, which opens multiple files in tabs by default.

Office App Problems