Excel guide · 5 min read
Excel spell check not working: why it skips words and how to fix it
Still not working on your sheet? Paste your cells and the formula into Cellwise Fix. The engine shows which cause it is on your data, then you get the fix, checked. Open Cellwise Fix
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | SKU | Description | Price | Web title |
| 2 | OF-1001 | Stainless steel water bottle | 14.5 | Stainless steel water bottle | OF-1001 |
| 3 | OF-1002 | Seperator tabs, 10 pack | 3.2 | Seperator tabs, 10 pack | OF-1002 |
| 4 | OF-1003 | WIRELESS MOUSE, GRAPHTE | 18 | WIRELESS MOUSE, GRAPHTE | OF-1003 |
| 5 | OF-1004 | USB-C hub, 4 port | 26 | USB-C hub, 4 port | OF-1004 |
| 6 | OF-1005 | Desk organiser, bambo | 22.75 | Desk organiser, bambo | OF-1005 |
| 7 | OF-1006 | Seperator tabs, 20 pack | 5.6 | Seperator tabs, 20 pack | OF-1006 |
| 8 | OF-1007 | Cable ties, assorted | 4.25 | Cable ties, assorted | OF-1007 |
Download this sheet as an Excel practice file (.xlsx)
Quick checks
Most "spell check isn't working" problems are spell check doing exactly what it's set to do. The sample product list has three typos: "Seperator" twice, "GRAPHTE" in capitals, and "bambo". Depending on what's selected and how the options are set, F7 can find all of them, some of them, or none.
- It found nothing at all? Check what was selected (cause 1) and whether you're still typing in a cell (cause 2).
- It missed a word in a column built with a formula? Formula cells are never checked (cause 3).
- It missed a word in CAPITALS or with a digit in it? Proofing options (cause 4).
- It flags correct words, or misses obvious ones? Wrong dictionary language or a bad custom dictionary entry (causes 5 and 6).
- It's greyed out or won't correct anything? Protected sheet (cause 7).
- It only checked one sheet? That's normal (cause 8).
1. More than one cell was selected
When a single cell is selected, Spelling checks the whole active sheet, including comments, page headers and footers, and graphics. When you select two or more cells, it checks only those cells. If you'd just selected column D to format it, F7 only looks at column D, and the typos in column B are never seen.
Click any single cell (A1 is fine) and press F7 again. On a laptop, F7 may be a media key: use Fn+F7 or Review > Spelling. Unlike Word, Excel desktop doesn't underline misspellings as you type, so nothing tells you about typos until you run the check.
2. You're still editing a cell
If the cursor is blinking inside a cell or the formula bar, F7 checks only the text in that cell (or the words you've highlighted in it). Press Enter or Esc so the status bar says Ready, then run Spelling.
3. Cells with formulas are never checked
Spell check skips any cell that contains a formula, including the text a formula returns. The web titles in column D are built with =B2&" | "&A2, so "Seperator tabs, 10 pack | OF-1002" in D3 is never flagged, even though the typo is right there on screen.
Fix typos at the source: the typed text the formula reads (column B here), then the formula results update. To find a known misspelling everywhere, including in formula results, use COUNTIF with wildcards or Find (Ctrl+F, Look in: Values).
Result: 2
2: two formula results in column D contain "Seperat", which F7 would never report. COUNTIF isn't case-sensitive, so it catches "Seperator" too.
How do I list every row with a known typo?
In Excel 365, FILTER with SEARCH returns the SKUs whose description contains it, so you can fix them in one pass with Find and Replace (Ctrl+H).
Result: spills 2 rows × 1 column
| OF-1002 |
| OF-1006 |
OF-1002 and OF-1006, the two separator rows.
4. UPPERCASE words and words with numbers are skipped
Go to File > Options > Proofing. Under "When correcting spelling in Microsoft Office programs", two boxes are ticked by default: "Ignore words in UPPERCASE" and "Ignore words that contain numbers". With the first one on, "GRAPHTE" in the all-caps description is never checked. With the second, a typo glued to a number, like "4port", is skipped.
Untick them if your data is full of capitals, for example product names exported from an old system. Expect more false alarms from codes and abbreviations; use Ignore All for those during the check. "Ignore Internet and file addresses" works the same way for web addresses and file paths.
These options are shared by the Office apps, so changing them in Excel changes them in Word and PowerPoint too.
5. The dictionary language doesn't match your text
Spell check uses one dictionary language at a time. If it's set to English (United States), British spellings like "organiser" get flagged; set to English (United Kingdom) and "organizer" gets flagged instead. Set to a language with no proofing tools installed, it may find nothing at all.
Change it in File > Options > Proofing > Dictionary language, or in the Dictionary language box at the bottom of the Spelling dialog while the check is running. If the language you need isn't listed, install its proofing tools (an Office language pack) from Microsoft.
6. A wrong word was added to the custom dictionary
If someone clicked Add to Dictionary on a typo, it's treated as correct forever, in every Office app. Open File > Options > Proofing > Custom Dictionaries, select the dictionary (usually CUSTOM.DIC), click Edit Word List, and delete the bad entry. If Add to Dictionary is greyed out in the Spelling dialog, check that a custom dictionary is ticked in the same window.
Ignore All, by contrast, only skips the word for now; it doesn't change the dictionary.
7. The sheet is protected
On a protected sheet, Excel can't change locked cells, so spell check can't make corrections there and the Spelling command may not be available at all. Unprotect it with Review > Unprotect Sheet (you'll need the password if one was set), run Spelling, then protect it again with the same settings.
8. It only checks the active sheet
Spelling works on one sheet at a time. To check the whole workbook in one go, right-click any sheet tab, choose Select All Sheets, select a single cell, and press F7. Right-click a tab and choose Ungroup Sheets when you're done, or your next typing goes into every sheet at once.
If Excel is changing words you typed rather than flagging them, that's AutoCorrect, not spell check: see Excel AutoCorrect changing text. For replacing a typo across a sheet, see Find and Replace not working if Ctrl+H misses cells.
Common mistakes
Running F7 with a column still selected
Click one cell first. With several cells selected, Excel checks only those cells.
Expecting formula results to be checked
Fix the typed source text, or search for the misspelling with COUNTIF or Ctrl+F set to Look in: Values.
Leaving "Ignore words in UPPERCASE" on for all-caps data
Untick it in File > Options > Proofing while you check that data.
Clicking Add to Dictionary on a typo
Remove it in Custom Dictionaries > Edit Word List, or it will never be flagged again in any Office app.
FAQ
Why is Excel spell check not finding any errors?
Usually several cells were selected, so Excel only checked those, or the errors are in formula cells, UPPERCASE words or words with numbers, which are skipped. Select one cell, check File > Options > Proofing, and run Review > Spelling again.
Does Excel check spelling as you type?
The Excel desktop app doesn't underline misspelled words as you type the way Word does. Run Review > Spelling (F7) to check, and use AutoCorrect for typos you make often.
How do I spell check the whole workbook in Excel?
Right-click a sheet tab, choose Select All Sheets, click a single cell and press F7. Ungroup the sheets afterwards.
Why does Excel spell check skip some cells?
It skips cells with formulas, and by default words in all capitals, words containing numbers, and web or file addresses. The last three are options under File > Options > Proofing.
Functions used
COUNTIFCounts cells that matchFILTERKeeps matching rows, spillsSEARCHPosition of textISNUMBERIs it a number?
Related guides
- How to stop Excel AutoCorrect changing your text
- Excel Find and Replace not working: 8 fixes
- Excel keyboard shortcuts not working: causes and fixes
- How to replace text in Excel with a formula
- COUNTIF not working: causes and fixes
- How to calculate standard error in Excel
Updated