in excell lists choosing quickly from the list

  • Thread starter Thread starter shubb1
  • Start date Start date
S

shubb1

I am endeavouring to choose quickly from a list defined in a cell created in
excell. i.e if the list is:
Excellent
Good
Fair
Poor
ICan you get the cell to autoselect good if you start typing G?
 
Hi,

You could type all four words in say A1,A2,A3 and A4. Then highlight the
rows right click and hide them, when you start typing in A5 it should do what
you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List 1
Variable Validation List 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Need to have a dropdown list or allow other entry? 1
Help needed 0
macro Excel problem link cells with Data-Validation option 4
[values from validation list] 1
Choosing a date from a list based on two criteria 2

Back
Top