Correcting Cell Contents with AutoCorrect
Excel's AutoCorrect feature automatically corrects misspelled words as you type them. AutoCorrect comes with hundreds of text and symbol entries you can edit or remove. Add words and phrases to the AutoCorrect dictionary that you misspell, or add often-typed words and save time by just typing their initials. You could use AutoCorrect to automatically change the initials EPA to Environmental Protection Agency, for example. Use the AutoCorrect Exceptions dialog box to control how Excel handles capital letters .
Add an AutoCorrect Entry
Edit an AutoCorrect Entry
Change AutoCorrect Exceptions