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.
To do it in Excel, here is the answer:
a) Click on "Options" under "File". Click on "AutoCorrect Options" under "Proofing".
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.
c) In the WorkSheet type in the short code as shown below.
d) Excel automatically replaces the short code with the full text that was defined.