'%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 Hiding Characters at Certain Zoom Levels
Question details
Users experience an inconsistent text display issue where Excel truncates or hides characters in cells at specific zoom levels (such as 100%), but renders them correctly at other scales.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing, formatting, or editing spreadsheets at standard zoom levels on a monitor.
- Observed behavior
- Cell text appears truncated or characters are hidden entirely at 100% zoom, but display normally when the zoom is changed to 85% or when viewing the document in Print Preview.
Before proceeding, ensure your graphics card drivers are up to date and check if the issue persists across all workbooks or is isolated to a specific spreadsheet with custom font settings.
Verify Document Output Using Print Preview
Since text disappearing is a known display rendering bug, using Print Preview will confirm that your actual data is intact and will print correctly.
This rendering glitch only affects the visual display on your monitor at certain scaling intervals. The underlying data in your spreadsheet is completely safe.
Launch Microsoft Excel and open the spreadsheet where the characters appear to be hidden.
Click on the "File" tab in the top ribbon and select "Print" from the left sidebar, or simply press the Ctrl + P shortcut on your keyboard.
Look at the Print Preview pane on the right side. Verify that all previously hidden characters and text are visible and formatting is correct.
Adjust Excel Zoom Settings
Change the zoom level to a percentage where the text renders correctly on your screen to continue working without visual interruption.
Report the Rendering Issue to Microsoft
Because this is a long-standing behavior in the software, submitting detailed feedback helps Microsoft developers prioritize a permanent fix in future updates.
Try WPS Spreadsheet for Reliable Document Rendering
If Excel's zoom display bugs are frustrating your workflow, WPS Office offers a highly compatible, free alternative with stable rendering, a familiar interface, and flawless performance across all zoom levels.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and click "Open" to locate your existing Excel file.
- 3. View Without Errors: Work on your document smoothly without experiencing missing characters or text rendering bugs.
Frequently Asked Questions
Why does Excel hide text at 100% zoom but show it at 85%?
This is a known display rendering issue in Microsoft Excel. It happens due to how the software's graphics engine scales fonts and column widths at specific screen resolutions. The data is still there, but the screen rendering temporarily fails to display it.
Will the hidden text be missing if I print or export the spreadsheet?
No, the hidden text will not be missing in your final output. You can verify this by opening Print Preview (Ctrl + P). If the text appears correctly in Print Preview, it will print or export to PDF perfectly despite the display error.
Can changing the font fix the zoom rendering issue?
Sometimes. Changing the font size, switching to a standard font like Arial or Calibri, or slightly widening the affected column can force Excel to recalculate the visual space and temporarily bypass the bug.
