How to Fix Hindi Text Not Displaying Correctly in Excel
Question details
Hindi text formatted with the Kruti Dev 011 font fails to display properly in the Excel workbook.
- Product
- Excel
- Device & OS
- Windows
- Scenario
- Opening or viewing an Excel spreadsheet that contains Hindi text typed in specific regional fonts.
- Observed behavior
- The Hindi text appears as unreadable English characters, random symbols, or incorrect formatting instead of the proper Hindi script.
Ensure you have downloaded the correct Kruti Dev 011 font (.ttf or .otf) file from a trusted typography website to your local storage.
Install the Missing Hindi Font and Restart Windows
The most common reason for Hindi text not displaying correctly is that the specific font used to create the document is missing from your system.
Non-Unicode fonts like Kruti Dev 011 must be installed on every computer that opens the file. If the font is missing, Excel will fall back to a default system font, making the text look like gibberish.
Find the downloaded Kruti Dev 011 font file on your computer, which typically ends in a .ttf or .otf extension.
Right-click the font file and select 'Install' or 'Install for all users' from the context menu to add it to your Windows font library.
Close all open applications and restart Windows. A restart is often required for Office applications to properly recognize newly installed fonts.
Launch Excel and open your workbook again. The Hindi text should now display correctly in the Kruti Dev 011 font.
Easily Read and Edit Hindi Text with WPS Spreadsheet
WPS Office fully supports regional fonts, including Kruti Dev 011 and Mangal. You can easily view, edit, and format Hindi text in your spreadsheets without compatibility issues.
- 1. Install WPS Office: Download and install WPS Office on your computer from the official website.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open the file containing your Hindi text.
- 3. Apply the Hindi font: Select the cells with the unreadable text, go to the 'Home' tab, and choose 'Kruti Dev 011' from the font drop-down list.
Frequently Asked Questions
Why does my Hindi text show as English gibberish in Excel?
This happens because the text was typed using a non-Unicode font like Kruti Dev. If that specific font is not installed on your current device, Excel substitutes it with a default English font, displaying the underlying keystrokes instead of Hindi characters.
How do I know which Hindi font is missing?
Select the affected cell in your Excel spreadsheet and look at the Font box in the Home ribbon tab. It will display the name of the originally applied font, allowing you to search for and download it.
Can I convert Kruti Dev text to standard Unicode?
Yes, you can copy the unreadable text and paste it into a free online 'Kruti Dev to Unicode' converter. Once converted to a Unicode font (like Mangal), you can paste it back into Excel, and it will display correctly on any device without requiring special font installations.
