in excell lists choosing quickly from the list

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?
 
W

Warren Easton

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