How to Save and Restore Word and Excel Window Positions
Question details
The user wants Word and Excel to consistently remember and restore their window sizes and screen positions after a computer restart, particularly on multi-monitor setups.
- Product
- Microsoft Word and Excel
- Device & OS
- not provided
- Scenario
- Reopening Word and Excel applications after a system restart to resume work across multiple monitors.
- Observed behavior
- The applications do not reliably remember or restore their previous window sizes and positions on the assigned screens.
Ensure your external monitors are securely connected, turned on, and fully recognized by your operating system before adjusting application window configurations.
Use the SaveViewLocMulti Add-in for Microsoft Word
Since native window restoring can be unreliable with multiple monitors, this add-in forces Word to remember document zoom, view, and exact window placement.
Microsoft Word typically attempts to reopen using the size and position of the last closed document, but multi-monitor setups often disrupt this behavior. A dedicated macro or add-in is the most reliable way to enforce window coordinates.
Close all active Word documents except for one. Resize and position this single window exactly where you want it to appear on your desired monitor.
Download and install the SaveViewLocMulti add-in (or a comparable window-saving macro) specifically designed to save Word screen locations.
Navigate to File > Options > Trust Center > Trust Center Settings > Macro Settings. Ensure that macros are enabled so the add-in can run automatically upon launch.
Close the Word application. The add-in will record the window's coordinates and reapply them the next time you open a document.
Rely on Native Last-Closed Behavior for Excel
While there is no direct equivalent add-in for Excel, you can optimize its native behavior by ensuring your customized window is the absolute last one closed.
Experience Seamless Window Management with WPS Office
If Microsoft Office struggles to maintain your preferred window layouts across multiple monitors, consider switching to WPS Office. It offers a modern, tabbed interface that simplifies document management and maintains excellent compatibility with all standard formats.
Frequently Asked Questions
Why does Word open on the wrong monitor?
When using multiple monitors, Word may default to the primary display or lose its previous coordinates if the monitor configuration temporarily changes (such as during system sleep or a restart). Using a dedicated window-saving add-in can force it to remember the correct display.
Is there a SaveViewLocMulti equivalent for Excel?
Currently, there is no widely known equivalent add-in specifically built for Excel to remember exact multi-monitor coordinates. You must rely on closing the customized Excel window last, so the system records its final position.
How does the 'last closed window' rule work in Office?
Microsoft Office applications write their window size and position to the system registry when the application closes. The very last window closed overwrites any previous coordinate settings, dictating the starting position for your next launch.
