Cellwise Start free

Excel guide · 5 min read

Excel spell check not working: why it skips words and how to fix it

Quick answerExcel's spell check (Review > Spelling, or F7) only checks the selected cells when more than one cell is selected, never checks cells that contain formulas, and by default skips words in UPPERCASE and words with numbers. Select a single cell to check the whole sheet, check the options under File > Options > Proofing, make sure the dictionary language matches your text, and unprotect the sheet first.

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.

RowABCD
1SKUDescriptionPriceWeb title
2OF-1001Stainless steel water bottle14.5Stainless steel water bottle | OF-1001
3OF-1002Seperator tabs, 10 pack3.2Seperator tabs, 10 pack | OF-1002
4OF-1003WIRELESS MOUSE, GRAPHTE18WIRELESS MOUSE, GRAPHTE | OF-1003
5OF-1004USB-C hub, 4 port26USB-C hub, 4 port | OF-1004
6OF-1005Desk organiser, bambo22.75Desk organiser, bambo | OF-1005
7OF-1006Seperator tabs, 20 pack5.6Seperator tabs, 20 pack | OF-1006
8OF-1007Cable ties, assorted4.25Cable 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).

=COUNTIF(D2:D8,"*seperat*")

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).

=FILTER(A2:A8,ISNUMBER(SEARCH("seperat",B2:B8)))

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

Related guides

Updated