Language Settings in Excel Workbooks
Setting the correct language in your Excel workbook ensures screen readers pronounce content correctly. This is especially important for workbooks that will be shared internationally or contain multiple languages.
What This Means
The workbook language setting determines how screen readers pronounce text, dates, numbers, and other content. An incorrect setting can make content difficult or impossible to understand when read aloud.
Why It Matters
- Screen readers use language settings to determine pronunciation
- Mispronounced content is confusing or unintelligible
- Numbers and dates are read differently in different languages
- Proper language settings ensure comprehension
Common Violations
XLSX-04-001: Workbook Language Is Not Set {#XLSX-04-001}
What's Wrong: The workbook doesn't have a primary language specified, or the default language doesn't match the content.
Impact: Serious - Screen readers may mispronounce content throughout the workbook.
How to Identify:
- Check the language indicator in Excel's status bar (bottom of window)
- Go to Review > Language to see current settings
- If content is in one language but settings show another, there's a mismatch
How to Fix:
Setting Workbook Language:
- Select all cells (Ctrl+A)
- Go to Review > Language
- Select Set Proofing Language
- Choose the correct language
- Click OK
Or via Options:
- Go to File > Options
- Select Language
- Set your preferred language under Office authoring languages
- Click OK
Language and Regional Settings
Number Formats
Different regions use different number formats:
- US: 1,234.56 (comma for thousands, period for decimal)
- Europe: 1.234,56 (period for thousands, comma for decimal)
Setting Number Format:
- Select cells with numbers
- Go to Home > Number group
- Click the dropdown arrow
- Select More Number Formats
- Choose the appropriate locale
Date Formats
Date formats vary by region:
- US: MM/DD/YYYY
- UK: DD/MM/YYYY
- ISO: YYYY-MM-DD
Setting Date Format:
- Select cells with dates
- Right-click > Format Cells
- Choose Date category
- Select locale in the Locale dropdown
- Choose the appropriate format
Currency Formats
Currency symbols and positions differ:
- US: $1,234.56
- Europe: 1.234,56 €
- UK: £1,234.56
Multi-Language Workbooks
If your workbook contains multiple languages:
Mark Different Language Sections
- Select cells in a different language
- Go to Review > Language > Set Proofing Language
- Select the appropriate language for those cells
- Click OK
Consistent Approach
- Use consistent language settings within each sheet
- Consider separating languages into different sheets
- Document language usage for other users
Screen Reader Behavior
Screen readers handle languages differently:
With Correct Language Set:
- Numbers read with appropriate format ("one thousand two hundred thirty-four")
- Dates read in local format
- Text pronounced correctly
With Incorrect Language Set:
- Numbers may be mispronounced
- Dates may be confusing
- Text may be unrecognizable
Proofing Language vs. Display Language
Proofing Language:
- Affects spell check and grammar
- Determines how screen readers pronounce content
- Can be set per-cell or per-range
Display Language:
- Controls Excel's interface language
- Menu items, ribbons, dialogs
- Separate from content language
Both should typically match the content language for best results.
Best Practices
Do:
- Set the workbook language before creating content
- Match language settings to content language
- Use consistent settings throughout
- Mark foreign language sections appropriately
Don't:
- Assume default settings are correct
- Mix languages without marking them
- Ignore language when distributing internationally
- Forget to check language settings before sharing
Checking Your Settings
Before distributing a workbook:
- Review > Language - Check current setting
- Status bar - See language indicator
- Run spell check - Verifies proofing language
- Test with screen reader - Confirm pronunciation