Excel 2010 Bible

Part IV: Using Advanced Excel Features

672

FIGURE 32.17

Use the Spelling dialog box to locate and correct spelling errors in your worksheets.

The Spelling dialog box works similarly to other spell checkers with which you may be familiar. If

Excel encounters a word that isn’t in the current dictionary or that is misspelled, it offers a list of

suggestions. You can respond by clicking one of these buttons:

l (^) Ignore Once: Ignore the word and continues the spell check.
l Ignore All: Ignore the word and all subsequent occurrences of it.
l (^) Add to Dictionary: Add the word to the dictionary.
l Change: Change the word to the selected word in the Suggestions list.
l (^) Change All: Change the word to the selected word in the Suggestions list and change all
subsequent occurrences of it without asking.
l (^) AutoCorrect: Add the misspelled word and its correct spelling (which you select from the
list) to the AutoCorrect list.

Using AutoCorrect

AutoCorrect is a handy feature that automatically corrects common typing mistakes. You can also

add words to the list that Excel corrects automatically. The AutoCorrect dialog box appears in

Figure 32.18. To access this feature, choose File ➪ Options. In the Excel Options dialog box, click

the Proofing tab and then click the AutoCorrect Options button.

This dialog box has several options:

l Correct TWo INitial CApitals: Automatically corrects words with two initial uppercase

letters. For example, BUdget is converted to Budget. This mistake is common among fast

typists. You can click the Exceptions button to specify a list of exceptions to this rule.

l (^) Capitalize First Letter of Sentences: Capitalizes the first letter in a sentence. All other
letters are unchanged.