Eliminate (or reduce) Errors by Using Your Own Auto Correct.


Here is another time saving tip for you today, Excel not only has autocorrect, but you can instruct it to insert the correct words for you, even if you shorten them to a few letters, to save time when entering data.

I am using Excel 2013.

  • File- Options
  • Proofing- Auto Correct Options

auto correct your own data

 

  • In the Replace Text As You Type Box type N in the Replace Box
  • In the With box type NORTH
  • Hit Add
  • Hit Ok and then Ok again.

auto correct your own data1

We are all set up.  We just need to test it.  Yes it works!.  Think this could save you some time?.

create your own data view

Let me know in the comments below!

Want To Watch The Video?


More Excel Tips

MR Xl 40 formulas

excel-formulas-ad-5

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts