Office Settings & Configuration

How to Set Default Fonts for Asian and Non-Asian Text in Excel

John Wilson Oct 19, 2026 868 views

Question details

The user wants to configure Excel to use different default fonts automatically for Asian and non-Asian text, similar to the functionality available in Microsoft Word, PowerPoint, and Outlook.

How to Set Default Fonts for Asian and Non-Asian Text in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting spreadsheets that contain mixed-language text, where the user needs distinct typography standards applied automatically to Asian characters and non-Asian (Latin) characters.
Observed behavior: Excel currently lacks independent default font controls for different text categories, meaning users cannot set dual default fonts for Asian and non-Asian text.

Before you start

Microsoft Excel does not currently provide native support for setting separate default fonts for Asian and non-Asian text globally. You will need to rely on custom cell formatting or templates as alternative solutions.

Solution 1Recommended

Apply Custom Cell Styles for Mixed-Language Text

Create a reusable cell style with a font that best supports both character sets, allowing you to quickly apply it to your data without configuring fonts manually every time.

Since Excel's global settings and themes do not separate Asian and non-Asian text, the most efficient workaround is defining a specific Cell Style. While this does not automate the dual-font separation, it allows you to quickly standardize the appearance of mixed-language text using a comprehensive Unicode font.

Select a comprehensive font

Identify a font installed on your system that has excellent readability for both Asian and non-Asian characters (such as Microsoft YaHei, Yu Gothic, or Arial Unicode MS).

Create a new cell style

Go to the 'Home' tab on the Excel ribbon, click on 'Cell Styles' in the Styles group, and select 'New Cell Style'.

Format the style

Name your new style (e.g., 'Mixed Language'), click the 'Format' button, navigate to the 'Font' tab, and select your chosen font. Click 'OK' to save.

Apply the style

Select the cells containing your Asian and non-Asian text, open the 'Cell Styles' menu again, and click your newly created style to apply the formatting instantly.

Apply Custom Cell Styles for Mixed-Language Text

Feature Limitation: This workaround unifies the text under a single font that supports both languages well, rather than assigning two different fonts natively as Word does.

Solution 2

Use Custom Excel Templates for Routine Tasks

If you frequently create documents requiring specific multilingual formatting, saving a pre-formatted workbook as a template saves significant setup time.

Free Microsoft Office alternative

Experience seamless spreadsheet formatting with WPS Office

While Microsoft Excel limits your ability to set dual default fonts for different languages natively, exploring alternative office suites can streamline your workflow. WPS Office offers a free, lightweight, and highly compatible suite that perfectly supports Microsoft Excel formats while providing an intuitive interface for all your multilingual data needs.

1. Download and install: Download WPS Office for free from the official website and install it on your device.
2. Open your spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing .xlsx files without losing any formatting.
3. Format with ease: Use the intuitive style options and extensive font support in WPS Office to manage your mixed-language data efficiently.

Completely free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsFamiliar user interface with zero learning curveRobust styling and formatting options for multilingual data

microsoft office alternative - wps office

Frequently Asked Questions

Why can I set Asian and non-Asian fonts in Word but not Excel?

Microsoft designed Word as a word processor with extensive multilingual desktop publishing capabilities. Excel, on the other hand, focuses primarily on data analysis and calculation, and therefore lacks the specialized, dual-language typography engine found in Word and PowerPoint.

Can Excel themes fix the mixed-language font issue?

No, Excel themes do not resolve this limitation. Theme fonts in Excel only dictate the global heading and body fonts, and they lack independent default font controls for specific language text categories like Asian and non-Asian characters.

Will Microsoft add this font feature to Excel in the future?

Microsoft actively reviews user feedback for future updates. You can submit your idea or vote on existing feature requests regarding Asian and non-Asian font settings via the official Microsoft Feedback Portal for Excel.

Office App Problems