Last updated: September 2019
Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Windows and MAC OSX operating systems.
Here’s a question that we received a few days ago:
Using Excel 2016 on Windows 10. As i am quite a fast typer i accidentally make quite a bit of spelling mistakes. For some reason i would expect that Excel would spell check as i type into the cell. If i recall correctly, Word does by default auto corrections in documents, so i would expect that Excel will behave similarly or i am wrong here? To me it seems that the Excel 2016 speller doesn’t work… How to spell check in my Excel spreadsheet?
Thanks for your question. It’s a good one. 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.
The spell checker in Excel is located in the Review tab.
In order to proof check your worksheet text, go ahead and proceed as following:
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:
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.
You might want to enable or disable spell checking autocorrects in your Office macros.
With Application.AutoCorrect 'this code turns on Automatic text corrections .ReplaceText = True end With
With Application.AutoCorrect 'this code turns off Automatic text corrections .ReplaceText = False end With
For completeness, in this section we’ll go ahead and review how the spell checking correction options work on Microsoft PowerPoint and Word.
Turning on Auto spell checks
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.
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.
In case of any questions, feel free to leave as a comment