Microsoft Office Tutorials and References
In Depth Information
Staying in Step with Insert
little spelling errors. With this in mind, you no longer have any excuse for
putting out worksheets with typos in the titles or headings.
To check the spelling in a worksheet, you have the following options:
✓ Click the Spelling command button on the Ribbon’s Review tab
✓ Press Alt+RS
✓ Press F7
Any way you do it, Excel begins checking the spelling of all text entries in the
worksheet. When the program comes across an unknown word, it displays
the Spelling dialog box, similar to the one shown in Figure 4-12.
Excel suggests replacements for the unknown word shown in the Not in
Dictionary text box with a likely replacement in the Suggestions list box
of the Spelling dialog box. If that replacement is incorrect, you can scroll
through the Suggestions list and click the correct replacement. Use the
Spelling dialog box options as follows:
✓ Ignore Once and Ignore All: When Excel’s spell check comes across
a word its dictionary finds suspicious but you know is viable, click the
Ignore Once button. If you don’t want the spell checker to bother
querying you about this word again, click the Ignore All button.
✓ Add to Dictionary: Click this button to add the unknown (to Excel)
word — such as your name — to a custom dictionary so that Excel won’t
flag it again when you check the spelling in the worksheet later on.
✓ Change: Click this button to replace the word listed in the Not in
Dictionary text box with the word Excel offers in the Suggestions list box.
✓ Change All: Click this button to change all occurrences of this
misspelled word in the worksheet to the word Excel displays in the
Suggestions list box.