Correcting Cell Contents with AutoCorrect

Excel’s AutoCorrect feature automatically corrects common capitalization and spelling errors as you type. AutoCorrect comes with hundreds of text and symbol entries you can edit or remove. You can 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. You can also use AutoCorrect to quickly insert symbols. For example, you can type (c) to insert ©. Use the AutoCorrect Exceptions dialog box to control how Excel handles capital letters. If you use math symbols in your work, you can use Math AutoCorrect to ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.