Automation using Autocorrect in Excel - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Friday, March 20, 2020

Automation using Autocorrect in Excel

Automation using Autocorrect in Excel
Sometimes our information is incomplete without the use of symbols. Inserting symbols that are accessible on keyboard are easy to punch in however, it is a tiring task if we have to insert symbols using symbol button in the ribbon above. And it is frustrating if we have to insert the same symbol over and over and over again!
But this can be worked out to make life a little easy in such situations.

Automating the process

It would have been much easier to insert the repetitive symbol in the worksheet if one types a text and Excel converts it to symbol automatically. But to make it happen we will have to make few tweaks inside Excel engine room!

Automation using Autocorrect!

Lets say we want Excel to automatically insert “->” if we key in “fwd”.
Following are the steps you need to take:
Step 1: Click File or office button at the top left corner and click options
Step 2: Click proofing from the options at the left of window
Step 3: Click Autocorrect options button. A new dialogue box will appear
Step 4: In replace input field type fwd and in with input field type ‘-> (yes starting with apostrophe)
Step 5: Hit Add button once and then Close button to close the dialogue.
Following screen grab walks you through the whole process:
insert symbol
And now type fwd anywhere in the worksbook or any subsequent workbook Excel will automatically convert the text to symbol on hitting Enter key.
If you don’t want it anymore or to make changes or to add more, now you know how to do it.
#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment