autocompleted text based values previously entered Column in Excel

Q114. In Excel, how can I have text autocomplete based on values previously entered in Column?

For example, instead of typing in Client Type for every client, if a client belongs to a type that has been typed in previously, I would like to make that selection.

excel autocompleted text based values previously entered column

To do it in Excel, here is the answer:

a) Right click on the cell where data needs to be entered and then click on "Pick From Drop-down List" as shown below.

excel excel autocompleted text based values previously entered column

b) List of all unique values in the column is displayed right below the cell. Click on the value needed.

excel excel excel autocompleted text based values previously entered column

c) The cell is updated with value chosen in the previous step.

excel excel excel excel autocompleted text based values previously entered column

 

You can find similar Excel Questions and Answer hereunder

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

2) How do I restrict user entry in ActiveX Text Box to just numeric values?

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

4) Remove the apostrophe cell text values in Excel

5) How can I have text autocomplete by typing in a short code for the text?

6) How do I calculate monthly payment given Loan amount, Rate of Interest and period?

7) I work with a SW that returns Hex values - how can I convert them to decimal values?

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

9) Vlookup to return multiple values in same cell in Excel

10) Concatenate number with text but keeping in number format in Excel

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

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

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

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

15) Generate a list of unique values in Excel