Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

Microsoft Office Excel 2007 includes a built-in spell checker that can catch and get rid of spelling errors and typos in your worksheets. Excel 2007's spell checker normally looks for misspellings only in the current worksheet. If you have a multiple-sheet workbook, you can select the sheets you want to check before you start the spell checker. Also, you can check the spelling of just a particular group of entries by selecting the cells first.

To check the spelling in a worksheet, follow these steps:

  1. Click the Spelling command button in the Proofing group of the Review tab (or press F7).

    Excel begins checking the spelling of text entries in the worksheet. When the program comes across an unknown word, it displays the Spelling dialog box.

    Use the Spelling dialog box in Excel 2007 to correct typos in a worksheet.
    Use the Spelling dialog box in Excel 2007 to correct typos in a worksheet.

    Excel suggests replacements for the unknown word shown in the Not in Dictionary text box with a likely replacement in the Suggestions list box. If that replacement is incorrect, you can scroll through the Suggestions list and click the correct replacement.

  2. Select one or more of the following dialog box options:

    • Ignore Once or 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 query you about this word again, click Ignore All.

    • Add to Dictionary: Click this button to add the unknown word — such as your name — to a custom dictionary so that Excel won’t flag it again.

    • Change: Click this button to replace the word listed in the Not in Dictionary text box with the selected word in the Suggestions list box.

    • Change All: Click this button to change all occurrences of this misspelled word in the worksheet to the selected word in the Suggestions list box.

    • AutoCorrect: Click this button to have Excel automatically correct this spelling error with the selected suggestion in the Suggestions list box (by adding the misspelling and suggestion to the AutoCorrect dialog box).

  3. Click OK when the spell check is complete.

If you began the spell check in a cell other than A1, you may see a dialog box asking if you want to continue checking at the beginning of the sheet. Click Yes or No to continue or end the spell check.

The Excel spell checker not only flags words not found in its built-in or custom dictionary, but also flags occurrences of double words in a cell entry (such as total total) and words with unusual capitalization (such as NEw York instead of New York). By default, the spell checker ignores numbers and Internet addresses. If you want it to ignore all words in uppercase letters as well, click the Options button at the bottom of the Spelling dialog box, and then select the Ignore Words in UPPERCASE check box before clicking OK.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: