Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature

Excel 2007's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries and typos with particular substitute text. But you can use AutoCorrect to alert Excel to your own particular typing errors and tell the program how it should automatically fix them for you.

You can add to the list of AutoCorrect text replacements at any time. These text replacements can be of two types: typos that you routinely make (along with the correct spellings), and abbreviations or acronyms that you type all the time (along with their full forms). Follow these steps:

1

Click the Office button and then click the Excel Options button.

The Excel Options dialog box appears.

2

Click the Proofing tab.

The Proofing options appear in the right pane.

3

Click the AutoCorrect Options button.

The AutoCorrect dialog box appears.

4

Select the Replace Text as You Type check box.

This check box is usually selected by default.

5

On the AutoCorrect tab, enter the typo in the Replace text box.

You also can enter an abbreviation here. Be sure that the text you type in the Replace box of the AutoCorrect dialog box isn’t a real word! Otherwise, you may unintentionally replace a commonly known word with other unwanted text.

6

Enter the correction in the With text box.

If you entered an abbreviation in the previous step, enter the full form of the text here.

7

Click the Add button and then click OK two times.

The new typo or abbreviation appears in the AutoCorrect list, and both dialog boxes close.

After you add an entry to the AutoCorrect list, whenever you type the abbreviated text or typo in your worksheet, Excel automatically replaces that text with the version that you entered in the With text box. For example, you may have informed Excel that whenever you type naaooa in the worksheet, that text should be replaced with National Association Against the Overuse of Acronyms; now, whenever you type naaooa, it will change into the full name of this fictional organization. You’ll see the correction after you press the spacebar (if you are entering multiple words in a cell) or after you complete the cell entry.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com