Font Errors in Excel: Causes and How to Fix Them

Hào Võ · Updated Nov 19, 2026

Lỗi Phông Chữ Trong Excel: Nguyên Nhân và Giải Pháp Chi Tiết

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.

Microsoft 365 for business · Call +84 28 3995 0359

Request adviceChat on ZaloCall hotline