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.
Correcting a Capital Mistake
As you are entering data in a worksheet, Excel can monitor what you type and make corrections for common mistakes. One such mistake is the accidental use of the Caps Lock key. This tip looks at how Excel can correct for this mistake.
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 Automatic Capitalization
Type some information into a worksheet, and you may notice that Excel automatically capitalizes some of your information. This happens because of an AutoCorrect setting that you can, if desired, change.
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.
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.