Excel: AutoCorrect

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. 

Example:

If you type the word "HEllo", it will be automatically converted to 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. 

AutoCorrect settings

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". 

NOTICE 

The AutoCorrect works between all Microsoft Office applications.