'%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)
How to Fix Weird Symbols in Excel for the Web on OneDrive
Question details
Excel workbooks display unreadable, strange symbols instead of normal text when viewed in Excel for the Web via OneDrive, despite looking normal in the desktop app.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Opening and viewing an Excel workbook in a web browser using OneDrive or Excel for the Web.
- Observed behavior
- Text in the spreadsheet is replaced by weird symbols. The issue persists across different browsers but does not affect the desktop Excel application.
Ensure you have editing permissions for the affected OneDrive file and take note of the original fonts used in your document before applying any changes.
Change the Font to Refresh Web Rendering
Changing the font to a widely supported option forces Excel for the Web to refresh its text rendering, which usually resolves the symbol display bug.
This issue is often caused by a temporary font-rendering glitch in Excel for the Web involving standard fonts like Arial or Times New Roman. Forcing a font change corrects the display.
Open the workbook in Excel for the Web, and highlight the specific cells, ranges, or the entire worksheet that is displaying the weird symbols.
Navigate to the Home tab and change the font from the drop-down menu to a standard web-safe option like Calibri or Arial.
Once the text becomes readable again, you can change the font back to your preferred original font. The text should remain normally displayed.
Ensure your changes are saved to OneDrive, then refresh the page or reopen the workbook to confirm the issue is completely resolved.
Upload a Fresh Copy of the Workbook
If changing the fonts directly in the web browser does not work, uploading a newly saved copy from the desktop application can overwrite the corrupted web file.
Avoid Web Rendering Bugs with WPS Office
If Excel for the Web continues to disrupt your workflow with strange symbols and rendering issues, consider switching to WPS Office. It provides a lightweight, fast, and highly compatible desktop alternative that correctly displays all your fonts and formatting without relying on web browser rendering.
- 1. Download and Install: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Open your Excel files: Launch WPS Spreadsheet and open your existing .xlsx files directly. No format conversion is required.
- 3. Edit with confidence: Enjoy stable font rendering and seamless editing with familiar tools, free from web-based display bugs.
Frequently Asked Questions
Why do my Excel files show weird symbols only on OneDrive?
This is typically caused by a font-rendering bug or missing web fonts in Excel for the Web. The desktop application has direct access to your local system fonts, which is why the text displays perfectly there while occasionally failing in the browser.
Will clearing my browser cache fix the weird symbols in Excel for the Web?
No. Based on user experiences, clearing browser history, cache, or switching to a completely different browser does not resolve this specific font rendering issue. Manually refreshing the font within the file is the most effective solution.
Can I keep my original fonts like Times New Roman?
Yes. You can select the unreadable text, temporarily change it to a standard font like Calibri to refresh the rendering engine, and then immediately change it back to your original font. The text should remain readable after saving.
