Fix Word and Excel Size Changes When Moving Between Monitors
Question details
The user needs to resolve an issue where Word and Excel windows drastically change size or scaling when moved from one monitor to another.

- Product
- Microsoft Word and Excel
- Device & OS
- Windows
- Scenario
- Moving Office application windows between a laptop display and an external monitor with different scaling configurations.
- Observed behavior
- Word documents and Excel workbooks appear much larger or smaller as soon as they are dragged to a different monitor.
Ensure that your external monitor is properly connected and that your Windows operating system is fully updated to optimally handle multi-monitor DPI scaling.
Match Display Scaling Percentages in Windows
Synchronize the scaling percentage across all connected monitors to prevent sizing glitches when dragging windows.
Different monitors often use different DPI (Dots Per Inch) scaling levels. When an Office application crosses over to a monitor with a different scaling percentage, it attempts to resize itself, causing the sudden jump in appearance.
Right-click anywhere on an empty space on your Windows desktop and select Display settings from the context menu.
Under the System > Display menu, click on the first monitor icon and note the percentage listed under the Scale and layout section.
Select your second monitor icon and adjust its Scale drop-down menu so that it matches the scaling percentage of the first monitor (e.g., set both to 100% or 125%).
Enable the Office Compatibility Optimization Setting
Configure Word and Excel to optimize for compatibility when working across multiple displays with varying resolutions.
Use Windows Keyboard Shortcuts to Move Windows
Moving the application window using keyboard shortcuts can sometimes bypass the visual scaling glitch associated with manual dragging.
Try WPS Office for a Seamless Multi-Monitor Experience
If display scaling issues persist in Microsoft Office 2016 or other older versions, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with smooth performance and rendering across multiple displays.
- 1. Download WPS Office: Visit the official WPS website and click the Download WPS Office Free button to get the installer.
- 2. Install the Application: Run the downloaded executable file and follow the quick on-screen instructions to install.
- 3. Open Your Files: Launch WPS Office and directly open your existing Word or Excel files to enjoy seamless multi-monitor editing.

Frequently Asked Questions
Why does my Excel window get huge when I drag it to my laptop screen?
This happens because the external monitor and your laptop screen have different DPI (Dots Per Inch) scaling settings in Windows. When you cross the boundary between screens, Windows tries to adjust the window size, resulting in a sudden jump in scale.
Does the 'Optimize for compatibility' setting exist in Office 2016?
No, the specific multi-monitor optimization settings introduced in newer Office 365 and Office 2019 versions are typically missing in Office 2016.
Will changing the display scaling affect my other applications?
Yes, adjusting the scaling percentage under Settings > System > Display will affect text size, app icons, and other items across the entire operating system on that specific monitor.




