65
University of Salford 47
Checking Your Spelling
You can use Excel’s spell checker to find and correct
spelling errors in your worksheets. To check the spelling
of a worksheet all at once, use the Spelling dialog box.
1. Click the Review tab on the Ribbon and click the
Spelling button in the Proofing group.
Excel begins checking spelling with the active cell.
Tip: Depending on which cell is active when you
start the spell check, you may see a dialog box
that asks you if you want to start your spell check
from the beginning of the sheet. Select Yes.
Other Ways to Check Spelling:
Press <F7>.
If Excel finds an error, the Spelling dialog box
appears with the misspelling in the “Not in
Dictionary” text box. You have several options to
choose from when the Spelling dialog box opens:
Ignore Once: Accepts the spelling and moves on
to the next spelling error.
Ignore All: Accepts the spelling and ignores all
future occurrences of the word in the worksheet.
Add to Dictionary: If a word is not recognized in
the Microsoft Office Dictionary, it is marked as
misspelled. This command adds the word to the
dictionary so it is recognized in the future.
Change: Changes the spelling of the word to the
spelling that is selected in the Suggestions list.
Change All: Changes all occurrences of the word
in the worksheet to the selected spelling.
Trap: Exercise caution when using this
command
—
you might end up changing
something you didn’t want to change.
AutoCorrect: Changes the spelling of the word to
the spelling that is selected in the Suggestions list,
and adds the misspelled word to the AutoCorrect
list so that Excel will automatically fix it
whenever you type it in the future.
2. If the word is spelled incorrectly, select the correct
spelling from the Suggestions list. Then click
Change, Change All, or AutoCorrect. If the word is
spelled correctly, click Ignore Once, Ignore All,
Add to Dictionary.
Excel applies the command and moves on to the next
misspelling.
Exercise Notes
•
Exercise File:
Mileage3-5.xlsx
•
Exercise: Run spell check and correct spelling for the
entire worksheet.
Figure 3-9: The Spelling dialog box.
Figure 3-10: This message appears when Excel is
finished checking the worksheet.
Editing a Worksheet