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.


Ø  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.


  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

  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 is truly outstanding and interesting spot to get the world best information researcher on an extremely moderate rate.


Powered by Blogger.