Microsoft Office Tutorials and References
In Depth Information
Click the Change button (Spelling
dialog box) to change the
misspelled word to the correct
word (Figure 2 – 62).
Click the Close button (Spelling
dialog box) to close the Spelling
If the Microsoft Excel dialog box
is displayed, click the OK button.
Click anywhere in the worksheet, such
as cell A18, to deselect the current cell.
Display the Home tab.
Click the Save button on the Quick
Access Toolbar to save the workbook.
Figure 2 – 62
What other actions can I take in the Spelling dialog box?
If one of the words in the Suggestions list is correct, click it and then click the Change
button. If none of the suggestions is correct, type the correct word in the Not in Dictionary
text box and then click the Change button. To change the word throughout the worksheet,
click the Change All button instead of the Change button. To skip correcting the word, click
the Ignore Once button. To have Excel ignore the word for the remainder of the worksheet,
click the Ignore All button.
1. Press F7
Additional Spell Checker Considerations
Consider these additional guidelines when using the spell checker:
To check the spelling of the text in a single cell, double-click the cell to make the
Always take the time
to check the formulas
of a worksheet before
submitting it to your
supervisor. You can check
formulas by clicking the
Error Checking button
(Formulas tab | Formula
Auditing group). You also
should test the formulas
by employing data that
tests the limits of formulas.
specialists spend as much
time testing a workbook
as they do creating it,
and they do so before
placing the workbook
formula bar active and then click the Spelling button (Review tab | Prooi ng group).
If you select a single cell so that the formula bar is not active and then start the
spell checker, Excel checks the remainder of the worksheet, including notes and
If you select a cell other than cell A1 before you start the spell checker, Excel will
display a dialog box when the spell checker reaches the end of the worksheet, asking
if you want to continue checking at the beginning.
If you select a range of cells before starting the spell checker, Excel checks the
spelling of the words only in the selected range.
To check the spelling of all the sheets in a workbook, right-click any sheet tab, click
Select All Sheets on the sheet tab shortcut menu, and then start the spell checker.
To add words to the dictionary such as your last name, click the Add to Dictionary
button in the Spelling dialog box (Figure 2 – 61) when Excel identii es the word as not
in the dictionary.
Click the AutoCorrect button (Spelling dialog box) to add the misspelled word
and the correct version of the word to the AutoCorrect list. For example, suppose
that you misspell the word, do, as the word, dox. When the spell checker displays
the Spelling dialog box with the correct word, do, in the Change to box, click the
AutoCorrect button. Then, anytime in the future that you type the word dox, Excel
automatically will change it to the word, do.