'%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 Opening at an Incorrect Zoom Level When Headings Are Hidden
Question details
Microsoft Excel workbooks open at an unexpectedly high zoom level when the 'Show Headings' option is unchecked.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Opening a saved workbook where the standard column and row headings have been hidden.
- Observed behavior
- The workbook ignores its saved zoom level (e.g., 80%) and opens at an incorrectly high zoom level.
Ensure you save any unsaved work in your open Excel files, as troubleshooting this issue requires closing and restarting the application in Safe Mode.
Troubleshoot and Disable Conflicting Add-ins via Safe Mode
Starting Excel in Safe Mode helps determine if a third-party COM or Excel add-in is causing the zoom level issue when headings are hidden.
Often, enabled COM add-ins such as Acrobat PDFMaker, Power Map for Excel, or Power Pivot for Excel can interfere with how the workbook renders when specific view settings are applied. Repairing Microsoft 365 usually does not fix this, so manually disabling the problematic add-in is required.
Press and hold the Ctrl key while clicking the Microsoft Excel shortcut to launch the application. Confirm that you want to start in Safe Mode, then open your workbook to see if the zoom level is correct.
If the workbook opens correctly in Safe Mode, close it, start Excel normally, and navigate to File > Options. Select "Add-ins" from the left-hand menu.
At the bottom of the Options window, select "COM Add-ins" (or "Excel Add-ins") from the Manage drop-down list and click the "Go..." button.
Uncheck the enabled add-ins one by one to disable them. Click OK, reopen the workbook, and check the zoom level. Repeat this process until you identify which add-in is causing the issue.
Switch to WPS Office for a Bug-Free Spreadsheet Experience
If Microsoft Excel add-ins continuously disrupt your display settings and workflow, consider switching to WPS Office. It provides a free, lightweight, and highly compatible alternative with a familiar interface, ensuring seamless migration without unexpected zoom glitches.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Microsoft Excel files without display issues.
Frequently Asked Questions
Why does hiding headings change my zoom level in Excel?
This is often a glitch caused by conflicting COM add-ins, such as Acrobat PDFMaker or Power Pivot, which interfere with how Excel renders the workbook view when standard UI elements are disabled.
What does opening Excel in Safe Mode actually do?
Opening Excel in Safe Mode launches the application without any customized settings, COM add-ins, or Excel add-ins. This is a diagnostic step to help you determine if a third-party plugin is responsible for your display issues.
Will running the Microsoft 365 repair tool fix add-in issues?
No, repairing or reinstalling Microsoft 365 typically does not resolve issues caused by third-party add-ins. You must manually identify and disable or update the specific add-in causing the problem.
How do I permanently remove a problematic COM add-in?
Go to File > Options > Add-ins, select COM Add-ins from the Manage dropdown, and click Go. Select the problematic add-in from the list and click the "Remove" button instead of just unchecking the box.
