Microsoft Office Tutorials and References
In Depth Information
Checking Spelling
If you wish to take a break, this is a good place to do so. Be sure to save the The Mobile Masses Biweekly
Payroll Report i le again and then you can quit Excel. To resume at a later time, start Excel, open the i le called The Mobile
Masses Biweekly Payroll Report and continue following the steps from this location forward.
Break Point:
Spell Checking
While Excel’s spell checker
is a valuable tool, it is
not infallible. You should
proofread your workbook
carefully by pointing to
each word and saying it
aloud as you point to it. Be
mindful of misused words
such as its and it’s, through
and though, and to and
too. Nothing undermines
a good impression more
than a professional
looking report with
misspelled words.
Checking Spelling
Excel includes a spell checker you can use to check a worksheet for spelling errors. The
spell checker looks for spelling errors by comparing words on the worksheet against
words contained in its standard dictionary. If you often use specialized terms that are not
in the standard dictionary, you may want to add them to a custom dictionary using the
Spelling dialog box.
When the spell checker i nds a word that is not in either dictionary, it displays the
word in the Spelling dialog box. You then can correct it if it is misspelled.
To Check Spelling on the Worksheet
To illustrate how Excel responds to a misspelled word, the following steps misspell purposely the word,
Employee, in cell A3 as the word, Empolyee, as shown in Figure 2 – 61.
Spelling button
1
Review tab
Spelling dialog box
Click cell A3 and then
type Empolyee
to misspell the word
Employee.
Ignore Once button
Select cell A1 so that
Ignore All and Change
All buttons impact words
throughout document
the spell checker
begins checking at
the selected cell.
Prooi ng group
Add to Dictionary button
desired word in
Suggestions list
Change button
Click Review on the
AutoCorrect button
Ribbon to display the
Review tab.
misspelled
word
Click the Spelling
indicates language to
spell check against
button (Review tab |
Prooi ng group) to
run the spell checker
and display the
misspelled word in the
Spelling dialog box
(Figure 2 – 61).
Figure 2 – 61
What happens when the spell checker i nds a misspelled word?
When the spell checker identii es that a cell contains a word not in its standard or custom
dictionary, it selects that cell as the active cell and displays the Spelling dialog box. The
Spelling dialog box lists the word not found in the dictionary and a list of suggested
corrections (Figure 2 – 61).
 
Search JabSto ::




Custom Search