How To Use AUTOCORRECT In Excel

Posted on by Sharath Raju

How awesome will it be, if you get someone who understands you best?

Excel has a command called

“AutoCorrect”

It can be your best partner, you just type two words and it will just display your choice.
Helpful in both shorthand data entry and misspelled words…

Excel has a few in-built terms which are wrongly entered many a time and it allows you to add your favorites to the existing list.

5 Steps to achieve the above

1.Choose “File”

2.Click “Options”

3.Select “Proofing Tab”

4.In the Auto Correct dialog box displayed, add text which has to be replaced under “Replace :” Label and text to be replaced with under “With:” label

5.Click “Add” button

And you are done!!!

@Checkout the example below

1

In the above example, we have used “SR” as the abbreviation of “Sharath Raju”, once we have typed “SR” into a cell just press enter.

Note: Auto Correct terms are case sensitive .i.e “sr” and “SR” is not the same.

Hope the article has helped you…

Published by Sharath Raju

I am an engineer by profession and by heart :) It's been 7+ years since I have been working with software development and robotic process automation. I have implemented close to 80+ RPA processes in total by using Uipath. It is so true that someone learns more by not reading something but by practicing the skill. I have been trying to understand exactly where people who are just starting out their career struggle and understand the pain of struggling for hours trying to figure something out.I can help you with that. Having a passion to share my piece of content, I have created step-by-step easy-to-digest courses. My goal is to help you get ready for the future by learning new talents and becoming more productive by providing you with relevant and useful courses. I'm still learning and exploring my field of work :) Every feedback should be as valuable as you are to me, please feel free to reach out to me if you have any feedback, questions, or need any help.Thank You...

Leave a Reply

%d bloggers like this: