It’s spelled E-X-C-E-L. But if you’re asking "how do you spell Excel," you’re probably not trying to write the software name — you’re stuck with a column of customer names like "Jordyn" vs "Jordan", "Acme Corp" vs "Acmee Corp", or "2024-03-15" typed as "2024/03/15" in a report due in 90 minutes.
Quick Answer
You don’t “spell Excel” — you use Excel to spell-check other things. The software itself is always E-X-C-E-L. But Excel has four built-in ways to verify, correct, and standardize spelling *inside your worksheets*: the Review > Spelling dialog (F7), AutoCorrect rules, custom dictionary entries, and formula-driven validation using EXACT(), SUBSTITUTE(), and fuzzy matching with IFERROR(SEARCH()).
All the Methods
| Method | Time for 10K rows | Accuracy | Difficulty |
|---|---|---|---|
| F7 Spelling Dialog | ~45 sec (manual click-through) | High — uses Office dictionary + context | Low |
| AutoCorrect + Custom Dictionary | Instant on entry | Medium — only works on exact matches | Medium |
| Formula-Based Check (EXACT + SEARCH) | 0.2 sec (array calc) | Low-Medium — no fuzzy logic by default | Medium-High |
| Power Query Text.Transform (fuzzy match) | ~8 sec (first load) | Very High — handles typos, spacing, case | High |
| VBA SpellCheckRange() | ~3.1 sec (10K cells) | High — leverages native COM | High |
Method 1 Deep Dive
Press F7. That’s it. Excel opens the Spelling dialog and scans A1:Z1048576 — but only cells with text, no formulas, and only if they’re selected *before* you hit F7. Here’s what most people miss: if you select B2:B250 (client names) first, F7 checks only those cells — not the whole sheet. Try it now with this sample:
| B2 | B3 | B4 | B5 | B6 |
|---|---|---|---|---|
| Sarah Chen | Mikaela Jones | Rajiv Patel | Tayler Smith | Luisa Mendoza |
| Jenniffer Lopez | Davon Williams | Kaiya Nguyen | Alexis Reed | Quinn O’Malley |
Notice "Jenniffer" in B7? It’s flagged instantly. Click “Change” and Excel suggests “Jennifer”. But here’s the counterintuitive part: Excel won’t flag “O’Malley” unless your regional dictionary includes the apostrophe — and by default, it doesn’t. So if your sales team types “O’Malley”, “OMalley”, and “O Malley”, F7 catches *none* of them. You’ll need Method 2.
Also — and this trips up finance teams weekly — F7 ignores numbers formatted as text. If cell C10 contains "$45,200" but is stored as text (left-aligned, green triangle), F7 skips it. To force a check, wrap it: =TRIM(C10) in a helper column, then run F7 on that column.
Method 2 Deep Dive
Go to File > Options > Proofing > AutoCorrect Options. Or faster: Alt+T+A. This opens the AutoCorrect dialog — and yes, it’s where you fix “exel” → “Excel”, but more importantly, where you build your *own* correction list for internal terms.
Let’s say your company uses “QwickShip” (not “QuickShip”) and “NexGen Labs” (never “NextGen”). Add them:
- In “Replace”, type
QwickShip - In “With”, type
QwickShip(yes — same thing. Why? So Excel treats it as a known word and stops underlining it) - Click “Add”
Now go to Custom Dictionaries > Edit Word List. Add “NexGen Labs”, “Acme Corp”, “Zephyr Dynamics”, and “2024-Q3”. These appear in *every* Office app — Word, Outlook, Excel — and prevent red squiggles from breaking your credibility in client-facing sheets.
Here’s the surprise: Excel’s custom dictionary supports compound words *with spaces*, but *not* hyphens unless you add the full variant. So if your CRM exports “e-commerce”, you must add both “e-commerce” and “ecommerce” — otherwise, “e commerce” (space) won’t trigger either.
Try this live: In cell D1, type =PROPER(B2) — that gives you “Sarah Chen”. But if B2 was “sarah chen”, PROPER works. If it was “SARAH CHEN”, PROPER still works. But if it was “SaRah ChEn”, PROPER returns “Sarah Chen”. Good enough? Not for compliance reports. For those, combine it with a lookup:
=IFERROR(INDEX($F$2:$F$12,MATCH(UPPER(TRIM(D2)),$E$2:$E$12,0)),D2)Where E2:E12 holds canonical names in uppercase (“SARAH CHEN”), and F2:F12 holds the properly cased version (“Sarah Chen”). This catches typos *and* case noise in one step — no VBA needed.
Cheat Sheet
| Task | Shortcut / Steps | Notes |
|---|---|---|
| Run spell check on selected range | Select cells → F7 | Only checks selected cells — not entire sheet |
| Open AutoCorrect | Alt+T+A | Add internal terms here — e.g., “QwickShip” |
| Add word to custom dictionary | F7 → “Add to Dictionary” | Adds to *all* Office apps, not just Excel |
| Force text-only check (ignore numbers) | =TRIM(A1) in helper column, then F7 | Fixes false negatives on number-formatted-as-text |
| Case-normalize + match against master list | =IFERROR(INDEX(F2:F12,MATCH(UPPER(TRIM(A1)),E2:E12,0)),A1) | E2:E12 = master list in UPPER(); F2:F12 = clean versions |
| Find near-matches (typos) | Power Query → Transform → Format → Clean → then use “Fuzzy Matching” | Best for 500+ rows; handles “Jenniffer”→“Jennifer” reliably |