About checking and correcting spelling

Check spelling    When you check spelling, Microsoft Excel checks the entire active worksheet, including cell values, cell comments, embedded charts, text boxes, buttons, and headers and footers. However, Excel does not check protected worksheets, formulas, or text that results from a formula.

If the formula bar is active when you check spelling, Excel checks only the contents of the formula bar. If you have a range selected, only the range is checked.

Correct spelling and typing errors as you type    The AutoCorrect feature in Excel can correct common typing errors as you work. For example, you can specify that Excel change "adn" to "and" and change "their is" to "there is."

Note  Don't confuse the AutoCorrect feature with AutoComplete. The AutoComplete feature finishes typing a word that is used repeatedly in a column of a list after you type a few letters of the word or phrase. You can turn off both the AutoCorrect and the AutoComplete behaviors.

Add an AutoCorrect entry during a spelling check    If you misspell a word consistently, you can add the common misspelling as an AutoCorrect entry. The common misspelling is automatically corrected.

Add words to a custom spelling dictionary    If you use words that aren't in the main dictionary, such as acronyms or proper names, you can add the words to a custom dictionary so Excel questions the words only if they're misspelled.

Note  Excel shares spelling dictionaries and AutoCorrect entries with other Microsoft Office programs that you might use.