Microsoft Excel 2007 with Example

3 Basics

3.16 Worksheets: Spelling

Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list.

1. On the Review tab, click Spelling.

Click Spelling

2. Select a suggestion.

3. Click Change to correct the misspelling in cell A2.

Change

4. Click Change All to correct all instances of this misspelling (cell A2 and cell A7).

Change All

5. Click Ignore Once to ignore the misspelling in cell A2. Click Ignore All to ignore all instances of this misspelling.

6a. Click Add to Dictionary to add this word to your custom dictionary.

Add to Dictionary

6b. To edit this list, click Options (or if you don't have this screen open, click File, Options, Proofing), and then click Custom Dictionaries.

Custom Dictionaries

7a. Click AutoCorrect to add this word to your AutoCorrect list (every time you type anwer, Excel will replace it with answer).

AutoCorrect

7b. To edit this list, click Options (or if you don't have this screen open, click File, Options, Proofing), and then click AutoCorrect Options.

AutoCorrect Options

Note: you can also add abbreviations to your AutoCorrect list. For example, if you type ee.com, Excel can replace it with www.excel-easy.com.