'%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 Excel Spell Check Not Working: Troubleshooting Guide
Question details
The user needs to troubleshoot and resolve an issue where the spell check feature fails to detect spelling errors or provide expected results.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to proofread and correct spelling errors in an Excel spreadsheet.
- Observed behavior
- Excel does not flag spelling errors, skips incorrect words, or fails to provide the expected spell-check suggestions when the tool is run.
Before modifying your proofing settings, ensure that your worksheet is not protected and that you have selected the specific cells or range you want to check, as Excel may skip unselected areas or locked cells.
Verify and Update Excel Proofing Options
Incorrect proofing configurations or missing dictionaries are the most common reasons the spell checker skips misspelled words.
Excel relies on specific proofing settings to determine which words to ignore (like uppercase words or words containing numbers). If these settings are misconfigured, or if the default dictionary is disabled, the spell check will not function as expected.
Click on the 'File' tab in the top-left corner of the Excel window, then select 'Options' at the very bottom of the menu.
In the Excel Options dialog box, click on 'Proofing' from the left-hand navigation pane.
Under the 'When correcting spelling in Microsoft Office programs' section, ensure that options like 'Ignore words in UPPERCASE' or 'Ignore words that contain numbers' are unchecked if you want those words checked.
Click on the 'Custom Dictionaries' button to ensure that the correct language dictionary is activated and set as the default.
Adjust Cell Language Settings
If the text is assigned a language that Excel does not recognize or lacks an installed dictionary for, the spell check will bypass those cells.
Perform a Manual Spell Check
Triggering the spell check manually forces Excel to scan the selected area, which is helpful if background checking is disabled.
Switch to WPS Office for Reliable Spreadsheet Proofing
If you frequently encounter frustrating issues with Excel's spell check or proofing settings, consider switching to WPS Office. It provides a lightweight, free alternative with built-in spell check, full compatibility with all Excel formats, and a familiar user interface that makes transitioning seamless.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your computer.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing Excel (.xlsx or .xls) files without losing any data.
- 3. Run Spell Check Flawlessly: Navigate to the Review tab and click 'Spell Check' (or press F7) to accurately proofread and correct your document.
Frequently Asked Questions
Why is Excel ignoring misspelled words in uppercase?
By default, Excel is often configured to ignore words typed entirely in uppercase. To change this, go to File > Options > Proofing, and uncheck the box next to 'Ignore words in UPPERCASE', then click OK.
Does Excel automatically highlight spelling errors as I type?
Unlike Microsoft Word, older or default versions of Excel do not always highlight misspelled words with a red squiggly line automatically. You may need to manually trigger the spell check by pressing F7 or checking your Proofing options to see if 'Check spelling as you type' is available and enabled.
How do I add a new dictionary language to Excel?
To add a new dictionary, go to File > Options > Language. Under the 'Office authoring languages and proofing' section, click 'Add a Language', select your preferred language, and click Add. You may need to restart Excel for the changes to take effect.
