Applicability: Office 2019, 2016, 2013; Office 365 and Standard.
Here’s a question that we received a few days ago:
I am currently using Excel 2016 on my Windows 10 based computer. As i am quite a fast typist, i often accidentally make quite a bit of spelling mistakes. For some reason i expected that Excel would spell check as i type into the cell. If i recall correctly, Word auto corrects your typos in documents, so i would expect that Excel will behave similarly or am i wrong here? To me it seems that the Excel 2016 speller doesn’t work… Any ideas?
Good question. Automatic spelling check is indeed one the key capabilities of the Office suite. As far as Text proofing, there is a fundamental difference between Excel and Word (or PowerPoint and OneNote). Turns out that Excel doesn’t have the ability to auto correct your spelling and grammar as you type text in the spreadsheet unless you specifically enabled it in the AutoCorrect Options (see below how to do it); whereas Word and PowerPoint do auto correct as you type. Let’s get started with Excel.
How to run spelling check in Excel?
First things first, the Excel spell checker is located in the Review tab.
In order to proof check your worksheet text, follow this process:
- Open your workbook and navigate to your worksheet.
- In the Ribbon, open the Review tab.
- Hit on Spelling.
- Your worksheet will be analyzed for errors, and Excel will provide suggested corrections in the Spelling dialog.
- In case of false-positives, you could Add to Dictionary relevant words or terms.
- Alternatively, hitting the F7 button will achieve the same results.
- Once done, hit on OK.
- Save your work as needed.
Enable Auto-Correct in Excel
The Spelling dialog which we just reviewed in the section above also allows you to trigger an AutoCorrect action. AutoCorrect automatically amends your content according to the rules you have defined under Options>>Proofing.
Some of the auto-correction rules you can define:
- Automatic capitalization of first letters in a sentence.
- Capitalization of Days
- Correction of Caps Lock accidentally pressed.
- And any automatic text replacement you might have
Note: Remember, the AutoCorrect capability spell check is not triggered automatically in Excel, you have to invoke it on your own. That’s the reason that Excel can’t spell check as you type your text.
Check Spelling Using VBA Macros
You might want to enable or disable spell checking auto-corrects in your Word and Excel VBA macros.
Enable text replacement in VBA:
With Application.AutoCorrect <p style="padding-left: 30px;">'this code turns on Automatic text corrections</p> <p style="padding-left: 30px;">.ReplaceText = True</p> end With
Turning Off text replacement in VBA:
With Application.AutoCorrect <p style="padding-left: 30px;">'this code turns off Automatic text corrections</p> <p style="padding-left: 30px;">.ReplaceText = <strong>False</strong></p> end With
Spell Checking in Word and PowerPoint
A few users asked about the auto spelling capabilities of other Microsoft Office suite applications. In this section we’ll go ahead and review how the spell checking correction options work on Microsoft PowerPoint and Word.
Manual proof checks
- Open the Word or PowerPoint file that you want to proof check.
- You can always find the Spelling & Grammar option under Review tab in the Proofing group.
- This will check the entire document for spelling errors.
- Alternatively, you can do this by just pressing F7 key, which ‘ll do the same job.
Turn on spell checks in Excel
As mentioned above, Word automatically checks your content and grammar as you type those. If for some reason, this capability is not enabled in your system, proceed as following.
- Click on Options under File menu.
- In the pop up window that opens, select Proofing.
- Under When correcting spelling and grammar in Word/Excel, check your desired options and click on OK.
Disabling Auto proofing
If for some reason, you would like to turn off ongoing auto spelling and grammar corrections as you type in your document, just go ahead and uncheck the first two boxes in the section highlighted in the section above.
If you are using Excel on macOS, the spellchecking function capabilities are quite consistent when compared to the Windows version. Here’s how to setup the speller
- Open your workbook in Microsoft Excel for mac.
- Navigate to the Review tab.
- Press the Spelling button.
- Excel will scan your worksheet for spelling mistakes.
- Once found you can either Ignore Once, Ignore All , Add new words to your Dictionary or Change based on Suggestion.
- AutoCorrect is also available as an option.
Note: In order to define the AutoCorrect rules in mac, proceed as following: In the upper Office for macOS Ribbon, hit Excel, then select Preferences and then select AutoCorrect. Now go ahead and define the required AutoCorrect rules for replacing erroneous text. Similar to the Windows version, Excel ships rules to correct common capitalization and hyperlinks keyboard mistakes as well as define custom rules.
In case of any questions, feel free to leave a comment 🙂
1 thought on “How to spell check in Excel 2019 / 365 and 2016 (automatically and manually)?”
I am using Excel 2010 and want to automatically correct/update the entire table of words (the majority of which are misspelled). The “change all” does not seem to work. F7 does work as expected. What am I missing?