Fix Excel Symbols Invisible or Displaying Incorrectly
Question details
Alt-code symbols such as diameter, degree, and plus-or-minus characters appear correctly for some users but are invisible or display incorrectly for others in shared Excel workbooks.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Viewing or editing Excel workbooks containing Alt-code symbols and special formatting.
- Observed behavior
- Symbols are missing, entirely invisible, or rendered as incorrect characters when the file is opened on a specific user's computer.
Before modifying any settings, test the same symbols in a brand-new blank workbook and in Microsoft Word to determine whether the issue is limited to one specific file or affects your entire system.
Apply a Standard Unicode Font
Changing the font can immediately resolve display errors if the originally applied font lacks support for specific Alt-code characters.
Highlight the cells or columns where the symbols are invisible or displaying incorrectly.
Navigate to the Home tab on the Excel ribbon and click the Font dropdown menu.
Choose a widely supported Unicode font such as Arial or Calibri, and check if the symbols become visible.
Disable COM Add-ins via Excel Safe Mode
Running Excel in Safe Mode helps identify if a third-party add-in is interfering with how symbols are rendered.
Clear XLSTART Folders and Reset Excel Registry Keys
If basic troubleshooting fails, resetting Excel's startup folders and registry keys can clear deep-seated configuration errors.
Experience Bug-Free Formatting with WPS Office
If Microsoft Excel continues to struggle with rendering Alt-code symbols or if registry fixes are too complex, try WPS Office. It provides a lightweight, highly compatible alternative that displays special characters and formats flawlessly, ensuring your shared workbooks look identical across all devices.
Frequently Asked Questions
Why do Alt-code symbols appear correctly for my coworkers but not for me?
This discrepancy usually happens due to missing fonts on your local system, incompatible COM add-ins interfering with your instance of Excel, or corrupted localized Excel configurations.
Can corrupted registry keys cause symbols to become invisible in Excel?
Yes, corrupted Microsoft Office registry keys or conflicting startup files in the XLSTART folder can cause display anomalies, including invisible text or missing special characters. Resetting these can restore normal behavior.
How do I know if a third-party add-in is causing my formatting issues?
You can verify this by launching Excel in Safe Mode (press Windows + R and type excel /safe). If the symbols display correctly in Safe Mode, a third-party COM add-in is likely responsible for the problem.
What exactly are Alt-code symbols?
Alt-code symbols are special characters—such as the degree symbol (°), diameter (Ø), or plus-or-minus (±)—that are inserted into documents by holding down the Alt key and typing a specific numeric code on the keyboard's numeric keypad.
