Excel 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.
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.
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 will replace it with 'Bennett/Porter & Associates'.
You can do this with city names or really anything that is long or difficult to type. Here are some examples:
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.