Using AutoCorrect For Shorthand Data Entry

You can use the AutoCorrect feature to create shortcuts for commonly used words or phrases. For example if you find yourself regularly typing a company name e.g. MasterExcel.net you can create an AutoCorrect entry for an abbreviation such as msx. Then whenever you type msx Excel automatically changes it to MasterExcel.net. In this example we will go through the steps on how this is done.

To set up your custom AutoCorrect entry access the Excel Options dialogue box
Click File > Options.
Click the Proofing tab.
Click AutoCorrect Options…..
AutoCorrect1

The AutoCorrect dialog box will now be displayed.

Click the AutoCorrect tab.
Check the option labelled Replace Text as You Type.

AutoCorrect2

In the Replace box input the shortcut you are using for the text.
In this example the shortcut is msx.

In the With box input the text related to the shortcut.
In this example the text is MasterExcel.net.

AutoCorrect3

Type the shortcut into any cell and press Enter.

AutoCorrect4

Notice that Excel replaces the shortcut with the full text.

AutoCorrect5

 

You can set up as many custom entries as you like. Just be careful not to use an abbreviation that might appear normally in your text.

Tip
Excel shares your AutoCorrect list with other Microsoft Office applications.
All AutoCorrect entries you created in Excel also work in Word and vice-versa.

Visual Example

AutoCorrect6




Be the first to comment

Leave a Reply