Excel Made Easy

Autocomplete text typing short code for the text in Excel

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.

You can find similar Excel Questions and Answer hereunder

1) Can I apply formatting to a number concatenated with a Text?

2) How can I enter a text in a cell with subscript and superscript?

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

4) How can I find the day of the week given a date?

5) Keyboard shortcut for save as in Excel

6) I conducted a test and the test scores are available - how can I get Percentile rank of students?

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

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

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

10) What is the view code button in the Excel Developer Tab