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.
 
Back
Top