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 doesnt work Any ideas.

As far as Text proofing, there is a fundamental difference between Excel and Word (or PowerPoint and OneNote).

Spell Check For Excel How To Do It

Turns out that Excel doesnt 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.

In case of false-positives, you could Add to Dictionary relevant words or terms.

Alternatively, hitting the F7 button will achieve the same results.

AutoCorrect automatically amends your content according to the rules you have defined under OptionsProofing.

Capitalization of Days Correction of Caps Lock accidentally pressed.

Thats the reason that Excel cant spell check as you type your text.

In this section well go ahead and review how the spell checking correction options work on Microsoft PowerPoint and Word.

You can always find the Spelling Grammar option under Review tab in the Proofing group.

Alternatively, you can do this by just pressing F7 key, which ll do the same job.

If for some reason, this capability is not enabled in your system, proceed as following.

Under When correcting spelling and grammar in WordExcel, check your desired options and click on OK.

Once found you can either Ignore Once, Ignore All, Add new words to your Dictionary or Change based on Suggestion.

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.

Spell Check For Excel Full Disclosure Page

Posts in this site may contain affiliate links, For more information you might want to read our Full disclosure page.

To find out more about our privacy policy and how to control cookies, see here.

Spell Check For Excel Mac