• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Checking Spelling

Checking Spelling

Click the Spelling button on the Standard toolbar. The Spelling dialog box opens, displaying the first spelling error it finds.

If the correct spelling of the word appears in the Suggestions list, click the word. If the correct spelling isn't listed, type the correction directly in the Not in Dictionary box.

Click Change to change only this instance of the word, or Change All to correct all instances in the workbook. Excel makes the change, and flags the next word.

INTRODUCTION

If your worksheet is for your eyes only, you might not think that misspellings are a big deal. But if you plan to turn over your worksheet to your manager, she might not think the mistakes are so minor. Fortunately, you can use Excel to check your spelling quickly and easily.


TIP

Adding words to your dictionary

If you notice that Excel incorrectly flags a word as a misspelling, you can add that word to the Office dictionary that Excel uses to check spelling. To do so, click the Add to Dictionary button in the Spelling dialog box.


If the word flagged by Excel is not misspelled (for example, it's a proper name), click Ignore Once to ignore this instance or Ignore All to ignore it throughout.

If you started the spelling check in the middle of the workbook, Excel checks until it reaches the end. If you want to continue checking from the beginning, click Yes.

As Excel continues locating spelling errors, change or ignore them as needed. Excel notifies you when all inaccuracies have been reviewed; click OK.

TIP

Checking from the beginning

You don't have to be at the beginning of a workbook when you check for spelling errors. If you start in the middle of a workbook, Excel checks until it reaches the end and then asks you whether you want to continue checking from the beginning of your workbook.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint