'%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 Win Innwa Font Display Problems in Excel AutoFilter
Question details
The user is experiencing incorrect display of Burmese text in Excel when using the AutoFilter feature with the legacy Win Innwa font.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Filtering data formatted with the non-Unicode Win Innwa font.
- Observed behavior
- Burmese text displays incorrectly in the AutoFilter dropdown, causing data compatibility and filtering problems.
Ensure you have a reliable Unicode-compatible Burmese font, such as Pyidaungsu, installed on your computer before attempting to reformat your data.
Convert Text to Unicode and Change the Font
The most effective way to resolve display and filtering issues with legacy fonts is to convert the underlying text data to standard Unicode.
Because Win Innwa relies on outdated character mapping, Excel's data management tools cannot interpret it correctly. Converting your text to standard Unicode ensures full compatibility across all features.
Use a reliable third-party font converter tool designed for Burmese text to convert your Win Innwa data into standard Unicode formatting.
Copy the newly converted Unicode text and paste it back into your Excel spreadsheet, replacing the old Win Innwa data.
Select the newly pasted cells, navigate to the 'Home' tab, and choose a fully compatible Unicode font like 'Pyidaungsu' from the Font dropdown menu.
Click on the AutoFilter dropdown arrow in your column header to verify that the Burmese text now displays and filters correctly.
Submit Feedback to Microsoft
If you are unable to convert your fonts and the issue heavily impacts your workflow, you can report the bug directly to Microsoft for future consideration.
Try WPS Office for Seamless Data Management
If you frequently encounter legacy font issues or compatibility bugs in Microsoft Excel, consider switching to WPS Office. It is a highly compatible, free alternative that offers excellent support for complex scripts and standard formatting, ensuring your spreadsheets look and function exactly as intended.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Open Your Workbook: Launch WPS Spreadsheet and seamlessly open your existing Excel files without losing any formatting.
- 3. Manage Your Data: Apply Unicode fonts, sort, and filter your data using a robust set of spreadsheet tools.
Frequently Asked Questions
Why does the Win Innwa font look corrupted in Excel AutoFilter?
Win Innwa is a legacy font that does not adhere to standard Unicode character mappings. Excel's AutoFilter feature reads the underlying character codes rather than the visual font, causing it to display incorrect or garbled characters.
Which fonts are recommended instead of Win Innwa?
It is highly recommended to use standard Unicode fonts for Burmese text. Popular, fully compatible alternatives include Pyidaungsu, Myanmar Text, and Padauk.
Will simply changing the font in Excel fix the display issue?
No, just selecting a new font from the dropdown menu will not fix the issue because the original text was typed using non-standard encodings. You must first convert the text data itself to standard Unicode using a converter tool before applying a new font.
