SECTION 2
Lesson 2.3 Editing Tools

   

 

 

AutoCorrect can help you avoid common spelling mistakes and typographical errors as you type. Excel keeps a list of common misspellings called AutoCorrect entries. If you type a misspelling that is in the AutoCorrect list, Excel will replace the mistake with the correct word when you press Enter or hit the Space Bar.

 

AutoCorrect also enforces rules such as capitalizing the first word in a sentence, capitalizing the names of days, and correcting two successive capital letters.

 

You can modify the AutoCorrect options by selecting Tools-> AutoCorrect Options from the Excel menu bar. This will display the AutoCorrect dialogue box.

 

 

 

You can configure a number of AutoCorrect behaviours by checking or clearing the AutoCorrect options in the Dialogue box.

 

You can also see a list of common symbols and misspellings, along with the symbols and words that AutoCorrect will use to replace them.

 

You can add your own replacement combinations to this list by clicking on the Replace text field, entering the text to be replaced, and then clicking on the With field, and entering the text to replace it with.