autocomplete text typing short code for the text in Excel

Q115. In Excel, how can I have text autocomplete by typing in a short code for the text?

For example, instead of typing in full Client Type text for every client, I would like to type in short codes like RC (RESELLER CORPORTAE), RG (RESELLER GOVERNMENT) etc., to save data entry time.

excel autocomplete text typing short code for the text

To do it in Excel, here is the answer:

a) Click on "Options" under "File". Click on "AutoCorrect Options" under "Proofing".

excel excel autocomplete text typing short code for the text

b) In the "AutoCorrect" dialog box, select "AutoCorrect" tab. In the "Replace:" field, enter short code. In the "With:" field enter the full Client Type. Click on "Add".

Repeat the process for every Client Type. Click OK.

excel excel excel autocomplete text typing short code for the text

c) In the WorkSheet type in the short code as shown below.

excel excel excel excel autocomplete text typing short code for the text

d) Excel automatically replaces the short code with the full text that was defined.

excel excel excel excel excel autocomplete text typing short code for the text

 

You can find similar Excel Questions and Answer hereunder

1) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

2) How do I change the rating numbers to rating labels?

3) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

4) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

5) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

6) Write to text file without quotes in vba in Excel

7) How can I get the most frequently occurring text in a range?

8) How can I have text autocomplete based on values previously entered in Column?

9) Converting numbers stored as text to numbers via macro in Excel

10) I want to add a trend indicator symbol next to my sales data - how can I do that?

11) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

12) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

13) How can I prevent users from seeing / accessing my macro code?

14) To easily identify sheets belonging to different Business Divisions, I would like to color code tab names - is it possible?

15) Vba delete entire row if contains certain text in Excel