As soon as you start typing text in your worksheet, the Excel AutoCorrect feature monitors every move you make and corrects minor errors, such as typos or lower and upper cases.
If you type the word “HEllo”, it will be automatically converted to the word “Hello”.
If you want to enter the word starting with a capital letter, but there was the Caps Lock key pressed, then the text “hELLO” will be changed to “Hello” and the Caps Lock key will automatically turn off.
The AutoCorrect feature can be adjusted in FILE >> Options >> Proofing >> AutoCorrect. You can select in which cases you want Excel to assist you when you typing. Here, you will find a list of words with the most common typos. You can either delete them or add the new ones.
Using AutoCorrect feature to create shortcuts
Note that you can use the AutoCorrect feature, not only to correct words but also to create abbreviations. For example, the notation “(c)” is automatically changed to “©”.
Let’s suppose that you want to create your own shortcut. For example, the phrase “to be continued”, which will be displayed when you type the word “tbc”.
In order to create it, go to FILE >> Options >> Proofing >> AutoCorrect Options. Then in the Replace textbox enter the abbreviated form “tbc”, and in the With textbox enter “to be continued”.
Now, each time you type text “tbc”, it will be replaced with “to be continued”.
The AutoCorrect works between all Microsoft Office applications.
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.