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.