AutoCorrect is a useful tool in Excel for applying specific formatting or spelling for certain phrases you often use. Excel pays attention to how you habitually type corrections and imitates your habits to make future typing easier on you. Learn how to take advantage of AutoCorrect and adjust the settings to your preferences with the following articles.

Tips, Tricks, and Answers

The following articles are available for the 'AutoCorrect' topic. Click the article''s title (shown in bold) to see the associated article.

   Automatically Capitalizing Day Names
When you enter a day name into a cell, Excel automatically capitalizes it. If you want to modify this behavior, follow the steps in this tip.

   Backing Up Your AutoCorrect Entries
Want to protect the information that you may be stored in your AutoCorrect entries? Just find a special type of file on your system and you can back up to your heart's content.

   Increasing the Capacity of AutoCorrect
AutoCorrect can be a great tool to, well, "correct" information that you type. If you get a little creative, you can even use it to insert large blocks of text in the place of small mnemonics you type. However, AutoCorrect has limits on the length of the replacement text. This tip discusses those limits and at least one way you can work around them.

   Turning Off Capital Corrections
Tired of having Excel second-guess you when you type a word that starts with two capital letters? You can turn off this AutoCorrect feature by following the steps in this tip.

   Unwanted Data Changes
The AutoCorrect feature in Excel can change some of your data in ways you don't like. If you discover this is happening, here's how to track down the problem and fix it.

   Using AutoCorrect
The AutoCorrect feature in Excel is a great tool for quickly entering information. Here's an explanation of the feature and a quick overview of how to use it.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.