in excell lists choosing quickly from the list
 

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?

in excell lists choosing quickly from the list
 

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.


--
Regards
Warren

If this helps please click the Yes button.


"shubb1" wrote:

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?