AutoCorrect Options

AutoCorrect Options: 

Repeat Complicated term on worksheets or workbooks, by just assigning short symbol for it.

If you are tired of entering complicated word many times , then the best way to make your work easy is to use AutoCorrect Options.
AutoCorrect Options, will replace the input text with corrected text. For that assign the Input text and Corrected text. As many times as you enter the input text , it will replace it with corrected text.

Steps:
a) Click on Office >> Excel Options >> Proofing >> AutoCorrect Option
b) On replace enter the corrected text (original text), in our example it is - Worcester, Massachusetts. And on With: option enter the short symbol , in our eg. it is- W, MA
c) Click on Add button, and close.

Now , as many times as you enter W, MA in a cell or in statement. It will automatically replace it with Worcester, Massachusetts.

If you, want to delete the assign symbol. Follow the same steps a) & b) above. Click on the symbol and then click delete button

Thank you !!