Tom’s Tutorials For Excel: Using AutoCorrect for Faster Data Entry

Tom’s Tutorials For Excel: Using AutoCorrect for Faster Data Entry

Here’s a tip for shortening the effort of entering recurring lengthy text.

Suppose there are words or phrases you need to type often in your spreadsheets, such as boilerplate legal text, or the name of your company. You can use AutoCorrect to tell Excel that when you type a certain combination of characters, what you really want is the lenghtier text to be entered.

For example, the name of my company is Atlas Programming Management. As a shortcut to save myself time and effort, I simply type APM to have my full company name be entered, as seen in the following Before and After pictures.



To use AutoCorrect in this way, press Alt+T+A to show the AutoCorrect dialog box.

In the AutoCorrect dialog box:
• Click onto the AutoCorrect tab.
• Enter the short text in the Replace field.
• Enter the lengthy text in the With field.
• Click the Add button.
• Click the OK button.