MICROSOFT EXCEL DATA ENTRY TIP: Let Excel Automatically Complete Your Abbreviations

Microsoft Excel is used for tabulation of data, which means you can enter data in rows and columns called spreadsheet, like the table below:

complete abbreviations in Microsoft Excel

Looking at this table, you’ll observe that all the company names end with “Nigeria Limited”.

Now, let’s say you have to manually enter a lot of data like these showing hundreds of company names. You know, that’s a lot of data to enter and a lot of work. Good news is that Microsoft Excel has a feature to automatically add the “Nigeria Limited” (or anything you want) to the company names when you hit an abbreviation you specify.

For example, you may specify that whenever you type nltd (or any other acronym you choose), Microsoft Excel should automatically replace it with Nigeria Limited. That way, you just type company name and type nltd, Excel completes the name for you, thereby saving you time and also reducing typing mistakes.

How To Do This:

1. Open Excel, Click File –> Click Options. See the figure below:

Microsoft Excel abbreviations


2. Click Proofing –> Click AutoCorrect Options. See figure below:

autocomplete abbreviations in Microsoft Excel


3. In the AutoCorrect dialogue box, type nltd (in Replace field), type Nigeria Limited (in With field) and Click Add. See figure below:

auto complete abbreviations in Microsoft Excel


4. Click OK in the AutoCorrect boxClick OK to close the Excel option box.

5. The Result: Whenever you type nltd and hit enter or space bar, Excel automatically writes Nigeria Limited.

autocomplete abbreviations in Microsoft Excel

Now, try this with any other abbreviation and replacement you want.

NOTE:

Ø  This is case sensitive, which means if you set nltd to get replaced with Nigeria Limited, it would not work with NLTD (upper case).
Ø  This is saved in Excel even after closing the workbook and opening it again. If you no longer want it, go to the AutoCorrect dialogue box and delete it manually.

Hope you find this tutorial helpful. Let me know your thoughts.

32 comments:

  1. Hi, I am Faiza. I can assist you with all kinds of Data Entry, Web Research, Copy Paste Work, Contact Details from Websites, PDF to Excel/Word, Image to Excel/Word, Typing in Excel/Word, , E-Manually Typing Work to Excel or Word Document and other various business related works. data entry

    ReplyDelete
  2. There are numerous kinds of a website from where the general population can without much of a stretch contract the information researcher for their information taking care of work, you can try this out https://activewizards.com/ is truly outstanding and interesting spot to get the world best information researcher on an extremely moderate rate.

    ReplyDelete
  3. This post is so informative and makes a piece of very nice information on the topic in my mind. It is the first time I visit your blog, but I was extremely impressed. Keep posting as I am gonna come to read it every day. data entry solutions India

    ReplyDelete
  4. that is a big article thank you for sharing this informative recommendation. i'm able to visit your weblog often for a few modern day call. i'm able to visit your blog regularly for a few today's say. Windows 10 Pro Keys Office 2019 Professional Plus CD Keys.

    ReplyDelete
  5. A gifted Data Scientists study issue, imagine designs crosswise over information, investigate information and utilize their insight and experience and finding to pick procedures and parameters that might be pertinent to the definite issue within reach. ExcelR Data Science Courses

    ReplyDelete
  6. For downloading this trial pack, you don't need to provide your payment details as in the case of Office 365 Home Premium trial. office professional plus 2019

    ReplyDelete
  7. The DPA makes a differentiation between close to home data and individual delicate data. ccanadianonline1

    ReplyDelete
  8. Pasarqq tempat Bermain judi bandarq online tentunya menjadi di antara pilihan yang tidak sedikit dipilih oleh pemain website bandarq .Bisa anda lihat profile terkait pasarqq ternama melalui metode klik link https://findery.com/pasarqq , lalu https://www.thebaynet.com/profile/noverakasanti888 kemudian https://fontlibrary.org/en/member/pasarqq/ dan juga http://www.myfolio.com/pasarqq.
    Selain itu juga pasarqq ini memiliki homepage personal seperti https://pasarqq.cabanova.com/
    http://rebuildingtogethernb.org/selamat-datang-di-situs-poker-online-pasarqq/
    http://sonidoslibertarios.org/selamat-datang-di-situs-poker-online-pasarqq/
    http://jonnymugwump.com/selamat-datang-di-situs-poker-online-pasarqq/

    ReplyDelete
  9. Halo pemburu data togel seperti data sydney bisa dilakukan melalui halaman ini dan juga data sgp beserta pengeluaran sydney.

    ReplyDelete
  10. Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. Microsoft CRM Credit Card Processing

    ReplyDelete
  11. Poker online situs terbaik yang kini dapat dimainkan seperti Bandar Poker yang menyediakan beberapa situs lainnya seperti http://62.171.128.49/hondaqq/ , kemudian , http://62.171.128.49/gelangqq/, dan http://62.171.128.49/seniqq. yang paling akhir yaitu http://62.171.128.49/pokerwalet/. Jangan lupa mendaftar di panenqq

    ReplyDelete
  12. Poker online situs terbaik yang kini dapat dimainkan seperti Bandar Poker yang menyediakan beberapa situs lainnya seperti http://62.171.128.49/hondaqq/ , kemudian http://62.171.128.49/gesitqq/, http://62.171.128.49/gelangqq/, dan http://62.171.128.49/seniqq. yang paling akhir yaitu http://62.171.128.49/pokerwalet/. Jangan lupa mendaftar di panenqq

    ReplyDelete
  13. Attractive, post. I just stumbled upon your weblog and wanted to say that I have liked browsing your blog posts. After all, I will surely subscribe to your feed, and I hope you will write again soon! 상품권 매입

    ReplyDelete
  14. Thanks for nice and informative post. If you lost your data and want your Data recover then techfix.ae is offering the data recovery services by professional IT engineers and technicians. To know more about us you can visit on Data recovery Dubai

    ReplyDelete
  15. The Professional Certification in Business Analytics is a foundation course for students and professionals who want to develop niche data skills for their chosen industry domain or function area. Become a Business Intelligence and Data Visualisation expert and surge ahead in your career. The nine-day Business Analytics certification course covers all the essential Analytical and Statistical techniques for effective business decision making. This programme introduces the student to the basic concepts of Python language.business analytics courses

    ReplyDelete
  16. Excellent! I love to post a comment that "The content of your post is awesome" Great work!

    digital marketing courses mumbai

    ReplyDelete
  17. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!

    data science course

    ReplyDelete
  18. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  19. Thanks for your insight for your fantastic posting. I’m exhilarated I have taken the time to see this. It is not enough; I will visit your site every day. Deepnude download

    ReplyDelete
  20. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

    Correlation vs Covariance

    ReplyDelete
  21. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  22. I am really very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post. data science training in aurangabad

    ReplyDelete
  23. Numerous organizations are searching for individuals that are eager to work on the web.data entry images

    ReplyDelete
  24. It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. data entry bpo solutions

    ReplyDelete

Powered by Blogger.