Microsoft Office Tutorials and References
In Depth Information
Checking for Errors
Change or Change All: Choose one of the
suggestions; then, click Change to change
just this incident of the spelling mistake or
select Change All if you think you could
have made the mistake more than once.
AutoCorrect: Have Excel, in future
workbooks, automatically correct the mistake
with the selected replacement.
Ignore Once: Click this button if you don’t
want to change the spelling of the
highlighted instance of the spelling.
Ignore All: Click this button if you don’t
want to change the spelling of any identical
instances of the spelling.
Using spell check to improve your worksheet.
Add to Dictionary: Add a word, such as a
proper name or medical or legal term, to
Excel’s built-in dictionary so that Excel won’t
flag it as a potential error in the future.
Optionally, press F7 to launch the Spell Check.
If, when you began the spell check, the current cell
was not at the beginning of the workbook, Excel
asks you whether to check the beginning of the
worksheet. When the spell check is complete, a
dialog box notifies you. Click OK.
Choose Review>Proofing>Spelling. If there are no
errors in the worksheet, a message box appears
advising you the spell check is complete; otherwise
it displays the Spelling dialog box seen in Figure
12-10, referencing the first error. Choose one of