'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Zoom Changing When Moving Between Monitors
Question details
Excel for Mac automatically changes its zoom level or window scaling when a workbook is moved from the main MacBook screen to an external monitor.
- Product
- Excel for Mac
- Device & OS
- macOS Monterey 12.6
- Scenario
- Dragging an active Excel workbook window between multiple displays with different resolutions.
- Observed behavior
- The workbook unexpectedly zooms in or out, making the spreadsheet appear distorted or the wrong size, while other Office applications function normally.
Before troubleshooting, save and close any open workbooks to prevent data loss, and verify which version of Excel for Mac you are currently running by clicking 'Excel' > 'About Microsoft Excel' in the top menu bar.
Revert to a Previous Version of Excel for Mac
Downgrading to an older, stable version of Excel bypasses the bug introduced in recent updates like version 16.70.
This zooming behavior is a known bug tied to specific updates of Excel for Mac (such as version 16.70) failing to properly manage display DPI scaling between multiple monitors. Rolling back the application to version 16.69.1 resolves the issue permanently until Microsoft releases a patch.
Open the 'Applications' folder on your Mac, locate Microsoft Excel, and drag it to the Trash to remove the buggy version.
Visit the official Microsoft Office for Mac Update History page in your browser. Locate the installer for version 16.69.1 (or another stable previous release) and download the package.
Run the downloaded installer to reinstall Excel. Once installed, open Excel, go to 'Help' > 'Check for Updates', and temporarily uncheck 'Automatically keep Microsoft Apps up to date' so it doesn't reinstall the problematic version.
Apply Quick Display Workarounds
If you prefer not to uninstall your current software, you can use these quick actions to reset the window size after moving it to the external monitor.
Try WPS Office for Seamless Multi-Monitor Support on Mac
Experience smooth, bug-free spreadsheet editing across all your displays. WPS Office is a lightweight, fully compatible, and free alternative to Microsoft Office that flawlessly handles multiple monitors on macOS without unexpected zoom or scaling changes.
- 1. Download WPS Office: Visit the official WPS website and download the free macOS installer package.
- 2. Install the Application: Open the downloaded file and drag the WPS Office icon into your Mac's Applications folder.
- 3. Edit Seamlessly: Launch WPS Office and open your spreadsheets to edit across multiple monitors with perfect scaling.
Frequently Asked Questions
Why does Excel change zoom when moved to my external monitor?
This is often caused by a known bug in certain Excel for Mac updates (like version 16.70) failing to properly adjust to different screen pixel densities or DPI scaling between the built-in MacBook screen and the external monitor.
Will updating my macOS fix the Excel zooming bug?
In most cases, this bug is isolated to the Microsoft Excel application itself rather than the Mac operating system. Reverting to an older version of Excel (like 16.69.1) is the most reliable fix.
How do I report this bug to Microsoft?
You can report the issue directly from Excel by clicking on the 'Help' menu at the top, selecting 'Feedback', and then choosing 'I Don't Like Something' to describe the multi-monitor zoom bug to their engineering team.
Does the web version of Excel have this multi-monitor bug?
No, using Excel Online through a web browser relies on your browser's window scaling rather than the desktop app's rendering engine. If your browser window changes size unexpectedly, you should check your browser's specific zoom settings.
