'%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 Incorrect Cell Sizes When Moving Between Monitors
Question details
Users experience cell rendering and sizing issues in Excel for Mac when dragging workbooks between multiple monitors.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Moving an active Excel workbook between multiple monitors that use different display scaling ratios.
- Observed behavior
- Worksheet cells render at the wrong size or appear distorted until the window is manually resized to trigger a display refresh.
Before troubleshooting, confirm which version of Excel for Mac you are currently running by clicking 'Excel' in the top Apple menu bar and selecting 'About Microsoft Excel'.
Update Excel for Mac to Version 16.71 or Later
The permanent fix for this cell rendering bug is to install the latest Microsoft update, which contains the official patch for the dual-monitor scaling issue.
Microsoft addressed this specific display scaling bug in the 16.71 build. Updating your application via Microsoft AutoUpdate will replace the buggy 16.70 rendering engine.
Launch Microsoft Excel on your Mac. In the top Apple menu bar, click on 'Help'.
Select 'Check for Updates' from the dropdown menu to open the Microsoft AutoUpdate utility.
Click the 'Update' button next to Excel to download and install version 16.71 or newer. Ensure you get the most recent build, as the fix was included in a secondary release of 16.71.
Use Window Resizing as a Temporary Workaround
If you cannot update Excel immediately, use this quick workaround to force the application to redraw the screen correctly.
Downgrade to an Earlier Stable Version
Since the display bug was introduced in version 16.70, rolling back to a previous stable build like 16.65 can resolve the issue if updating is not an option.
Use WPS Office as a Seamless Mac Alternative
If Microsoft Excel continues to experience display glitches on your multi-monitor setup, try WPS Office for Mac. It is a free, lightweight suite offering excellent cross-platform compatibility and highly stable rendering across multiple screens of varying resolutions.
Frequently Asked Questions
Why does display scaling affect Excel cell sizes on Mac?
Different monitors often have different pixel densities and scaling ratios. When you drag an application between them, the software must dynamically recalculate the user interface. Version 16.70 of Excel for Mac had a bug in this recalculation process, causing the spreadsheet grid to render at the wrong dimensions.
Does resizing the window permanently fix the Excel rendering glitch?
No, manually resizing the Excel window only triggers a temporary screen refresh that fixes the current view. If you move the window to another monitor again, the issue will return. The permanent fix requires updating Excel to version 16.71 or higher.
How do I report ongoing display bugs to Microsoft?
If you continue to experience scaling issues after updating, you can report it directly to Microsoft. Open Excel, click on the 'Help' menu at the top, and select 'Feedback' or 'Contact Support' to detail your specific monitor setup and the glitch.
