What Most People Miss About Excel’s Automatic Spell Check

Yes, Excel has automatic spell check — but it doesn’t run in the background like Word, and it won’t flag typos in cells you edited before turning it on (trust me, I learned this the hard way).

The Problem

You’re reviewing a quarterly vendor report. Sarah Chen from Acme Corp sent over Q3_Invoice_Summary.xlsx. You spot "reciept" in cell D7, "acommodate" in F12, and "seperate" in B19. But when you click Review → Spelling, Excel says "No spelling errors found." You double-check — same result. You start questioning your eyes.

This isn’t broken software. It’s silent by design. Excel’s spell checker only scans text you’ve typed *since* the feature was enabled — and it ignores formula results, merged cells, headers, and anything in a table column with mixed data types.

CellContentError Type
D7Reciept submitted for $4,250.00Typo ("reciept" → "receipt")
F12Acommodate rush delivery by 2024-03-15Typo ("acommodate" → "accommodate")
B19Seperate line items per PO# A-8872Typo ("seperate" → "separate")
E5=CONCATENATE("Order for ",C5," shipped")Formula — ignored entirely
A1:A3"Q3 Vendor Summary" (merged)Merged cell — skipped
G2:G10Mixed: "Pending", 42, "Urgent", "N/A"Non-text values break detection

The Solution

Fixing this takes four steps — and yes, you’ll need to re-scan manually once. But after that, new edits get caught instantly.

  1. Enable background checking: Go to File → Options → Proofing. Check "Check spelling as you type". Click OK.
  2. Force a full scan: Press Alt + F7 — this opens the Spelling dialog and checks every editable text cell in the active sheet (not just the current selection).
  3. Correct errors one-by-one: When Excel highlights "reciept" in D7, click Change (not Change All — that would mess up proper nouns like "Recier Logistics" in row 22).
  4. Verify formula outputs: Select cell E5, press F2 to edit, then Enter. This forces Excel to treat the formula’s result as newly entered text — now it’s eligible for spell check.

That last step is the sneaky one most people skip. Excel won’t spell-check formula results unless you trigger a recalc *and* re-enter the cell’s editing mode. It’s not intuitive — but it works.

CellBeforeAfterHow Fixed
D7Reciept submitted for $4,250.00Receipt submitted for $4,250.00Clicked Change in Spelling dialog
F12Acommodate rush delivery by 2024-03-15Accommodate rush delivery by 2024-03-15Clicked Change; ignored Change All
B19Seperate line items per PO# A-8872Separate line items per PO# A-8872Clicked Change; confirmed no “Seperate Inc.” in data
E5=CONCATENATE("Order for ",C5," shipped")Order for AlphaTech shippedPressed F2 → Enter to refresh text state
A1"Q3 Vendor Summary" (merged)Unmerged; text moved to A1Right-click → Unmerge Cells → retype in A1

Going Further

You can customize what Excel considers an error. In File → Options → Proofing → Custom Dictionaries, add company-specific terms like "ZyloSoft", "TerraVox API", or "Q4FY24" so they stop triggering false positives.

Need to check only part of a sheet? Select the range first (say, B2:D50), then press Alt + F7. Excel respects your selection — it won’t scan A1 or column E.

For reports shared across teams, embed a quick-check macro. Paste this into VBA (Alt + F11):

Sub QuickSpellCheck()
    ActiveSheet.Range("A1").CurrentRegion.Select
    Application.CommandBars.ExecuteMso "Spelling"
End Sub

Assign it to Ctrl + Shift + S — now one keystroke kicks off a full scan of all populated cells.

Here’s the counterintuitive tip: if you paste plain text from Outlook or Teams into Excel, spell check *won’t* fire — even with background checking on. You must click into the cell and press Enter first. Pasted content sits in a “pending” state until confirmed.

When NOT to Use This

Don’t rely on automatic spell check for:

  • Numbers formatted as text: "12345" in cell C8 won’t be flagged — but "twelve thousand" will. Excel treats numeric strings as data, not language.
  • Cells with data validation lists: If D2 uses a dropdown with "Shipped", "Pending", "Cancelled", Excel won’t check those entries — even if you type them manually later.
  • Protected sheets: Spell check is disabled entirely if the sheet is protected — even with no password. Unlock first.
  • Cells containing non-Latin scripts: Japanese, Arabic, or Hindi text won’t trigger red underlines unless you’ve installed matching proofing tools (they’re separate downloads from Microsoft).

And never use it as a substitute for human review on client-facing deliverables. Excel won’t catch "their/there/they’re" — or context errors like "We except your proposal" (should be "accept").

Keyboard Shortcuts

ActionShortcutNotes
Open Spelling dialogAlt + F7Works on selected range or full sheet
Edit cell (to refresh formula output)F2Then press Enter to confirm
Toggle background spell checkVia Options only — no direct shortcutMust go through File → Options → Proofing
Jump to next misspelled wordTab (in Spelling dialog)Only active inside the dialog box
Ignore all instances of current wordI (in Spelling dialog)Use sparingly — affects entire workbook
Lisa Anderson

Lisa Anderson

Lisa is a certified Microsoft trainer who writes step-by-step guides for Power Automate