Excel Tip Tuesday: Controlling Auto Correct in Excel

Posted by Lisa on January 29, 2019 at 10:30 AM

Excel IconExcel can be a real know-it-all sometimes. Do you find yourself fighting with the software when it wants to auto correct certain letters or words that you type in...and that you know are correct? For example, I have a customer number that is WYA and Excel changes it to 'WAY' every time. Well, you can tell Excel not to make these types of corrections anymore! 

Begin by navigating to the File > Options > Proofing and clicking on the AutoCorrect Options... button.

Excel Tips - Auto Correct1

On the AutoCorrect tab, scroll down to find the word that Excel is changing. From here you can simply highlight that entry and click the Delete button.

Excel Tips - Auto Correct2

While you're here, look at all the other options available. You can delete any other auto correct words from here...but you can also add new - and hopefully more useful - ones. For example, let’s say you have a customer or vendor with a really long name and, you don’t want to type it in every time you need to refer to them. You can set up an auto correct entry to replace certain letters with the full, spelled out name, such as having 'Bennett/Porter and Associates' replace the much shorter 'BP&'.

In the Replace box, you would type 'BP&', and in the With box you would type 'Bennett/Porter and Associates'. Then just click the Add button. Now every time you type 'BP&' and click Enter...

Excel Tips - Auto Correct4

...Excel will replace it with 'Bennett/Porter & Associates'.

Excel Tips - Auto Correct5

You can do this with city names or really anything that is long or difficult to type. Here are some examples:

Excel Tips - Auto Correct6

Save yourself the frustration of Excel auto correcting every time you type something, and definitely save yourself some time by adding auto correct options that are useful to you!

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel, Excel Tip Tuesday

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts