Like, Microsoft word, Excel also has the spell check feature, but most Excel users do not know or use this feature as Excel is majorly used for the number values rather than text data.
Spell check in Excel identifies the misspelled word and users can correct them using this Spell check feature.
If we compare, Spell check in Excel is not much advanced as in word where it checks the grammar mistakes, misspelled word, and underline the incorrect words but still it is a good option for Excel users to run this check to identify the misspelled words and to correct them.
Run Spell Check in Excel
- First, select the cell from where you want to run the spell check or select cell A1 to run the spell check from the entire sheet.
- After that, go to the “Review” tab and click on the “Spelling” icon under the “Proofing” group on the ribbon or press F7 as a shortcut key for spell check.
- Once you click on the “Spelling” spell check will start and if finds any misspelled word, the spelling dialog box will get opened.
- The spelling dialog box gives you multiple suggestion options to choose any one of them based on the misspelled word with multiple actions to take for that word like “Ignore Once, Change, Add to Dictionary” and many others.
- Now, you can choose the suggestion and click on “Change” to update the misspelled word for this time only or you can click on “Ignore Once” to ignore that misspelled word this time only or can click on “Add to Dictionary” to add that word to the spell-check dictionary.
- Once you are done with all the misspelled words, it will display the dialog box showing spell check complete and click OK.
Spell Check Dialog Box Options
- Ignore Once: Ignores the word found as misspelled only once, which means if the same word repeats in the sheet, it will find that word as misspelled again.
- Ignore All: Ignores the word found as misspelled for all the instances and will not show that repeated word as misspelled again within the worksheet.
- Add to Dictionary: In case you need any word to be used as same you entered (Mostly in case of Abbreviations) but spell check identifies that word as misspelled then you can add that word to the spell check dictionary so that whenever you use that word, spell check will not encounter it as misspelled.
- Change: Changes the misspelled word with the suggestion you select from the available suggestions for that misspelled word.
- Change All: Change the occurrence of the misspelled word with the suggestion you select.
- AutoCorrect: Changes the misspelled word with the suggestion and adds that suggestion into the autocorrect list and every time you enter that misspelled word, spell check auto corrects that word with that pre-selected suggestion.
Change Spell Check Default Settings in Excel
Spell check in Excel has some default settings that users can change by doing the below steps:
- First, click on the “Options” button in the spell check dialog box.
- Once you click on “Options”, it will open the “Excel Options” dialog box where you can change the default setting.
- Now, uncheck or check the default setting options you want to change and click OK.
Points to remember:
- Spell check identifies only the misspelled words.
- Spell check does not identify the words in uppercase and words with the number combination until you uncheck these default setting options.
- Spell check does not identify the words within the Excel formulas.
- Spell check runs from left to right direction row by row.
- If you click on any other cell than A1 and run spell check, it will ignore the cells to the left of the selected column in that row.
- If you select multiple cells and run spell check, it will only run through those selected cells.
- Spell check shows you the misspelled words one by one, which means wherein any cell it finds a mistake, it will open a spell check dialog box to take action on that mistake and once you have done, then it will show you the next misspelled if any.