Font errors in Excel are a common problem when working with spreadsheets. They make data hard to read and spoil the look of the workbook. This article explains the causes of font errors in Excel and effective ways to fix them.
Quick fixes for Excel font errors: (1) the font is not installed on your computer → install it, or select the data and change it to a common Unicode font (Calibri, Arial, Times New Roman); (2) Vietnamese text broken by legacy encodings (TCVN3/VNI) → convert to Unicode with Unikey Toolkit (Ctrl + Shift + F6); (3) set a default font: File > Options > General > Use this as the default font; (4) CSV files with broken accents → use Data > From Text/CSV and choose File Origin: UTF-8; (5) turn off graphics acceleration if text renders incorrectly: File > Options > Advanced > Display; (6) update or repair Office (Quick Repair); (7) rebuild the Windows font cache if fonts display wrongly across the system.
Why does Excel show font errors?
There are several causes. Understanding them helps you choose the right fix.
Incompatible fonts
Font errors often occur when you open a workbook created on another system that uses fonts not installed on your computer, especially custom fonts.
Encoding errors
Files can be saved in different formats, and the wrong encoding can make text display incorrectly. This often happens with CSV or TXT files exported from other systems.
Corrupted workbooks
A workbook can become corrupted through improper saving or software problems, and text may then display incorrectly.
System settings
Unsuitable system settings, especially Excel’s default font, can cause errors.
Signs of font errors
Wrong or strange characters
You may see invalid characters or text turned into unreadable symbols, especially Vietnamese characters with diacritics.
Distorted fonts
Letters do not look as originally formatted, or their size and style change.
Vietnamese text unreadable
For people working in Vietnamese, the most obvious sign is accented characters displaying as unrecognisable symbols.
Step-by-step fixes
Method 1: Check and change the font
Check whether the font in use exists on your system. If not, change it to a more common font: select the cells or the whole sheet and pick a new font on the ribbon.
Method 2: Convert the character encoding (Unicode, VNI, TCVN3)
If text displays incorrectly because of encoding, convert it. Tools such as Unikey Toolkit convert legacy Vietnamese encodings to Unicode.
Method 3: Install the missing font
If you want to use custom fonts, install them on your system, then reopen Excel and check whether the problem is fixed.
Method 4: Fix encoding when opening CSV/TXT files
Choose the correct encoding when importing: go to Data > From Text/CSV, select the file and set File Origin to 65001: Unicode (UTF-8), so Vietnamese characters display correctly.
Method 5: Repair a corrupted workbook
If you suspect the file is corrupted, use File > Open > select the file > arrow next to Open > Open and Repair. This can recover data and fix some display problems.
Tips to prevent font errors
Use common Unicode fonts
Choose widely available fonts such as Arial, Times New Roman, Calibri or Verdana for compatibility and full character support, including Vietnamese.
Save workbooks as .xlsx
The .xlsx format stores data reliably and reduces font problems when opening files on other systems.
Check fonts before sharing
When sharing a workbook, make sure the recipient has the fonts you used, or stick to standard fonts.
Frequently asked questions
- How do I know if a workbook has font errors? Check the text: strange or unreadable characters indicate a font or encoding problem.
- Is fixing font errors difficult? Usually not; often you only need to change the font or convert the encoding.
- Are there other ways to fix font errors? Yes, from installing new fonts to changing Excel’s default font settings.
We hope this article helps you solve font errors in Excel. For Office support on company PCs, contact IT Systems at hotline 028.3995.03.59 or contact@itsystems.com.vn.
Email or Outlook problems across your team?
IT Systems deploys Microsoft 365, migrates email, sets up security and supports users on Outlook, Teams and OneDrive.




