Drop Down List:scroll down

[ernie]

When i click on a dropdown list i have to scroll down to the name that i want
to select ... is there some way to type the first letter for the name i want
so that it go straight to the name or the list of names begining with the
letter so i can select the name i want instead of scrolling down the list .
its much quicker
--
help a friend help you

[L. Howard Kittle]

Hi Ernie,

Sort your list and then edit in this way. At the beginning of the A's
enter a single letter A, do the same for the top of the B's and the same for
all the alphabet of your list.

Now click on the Drop Down cell and enter the first letter of your choice,
perhaps an S. No need to hit enter, just click on the down arrow and the
list will begin with the S's.

HTH
Regards,
Howard

"ernie" <[email protected]> wrote in message
news:[email protected]...
> When i click on a dropdown list i have to scroll down to the name that i
> want
> to select ... is there some way to type the first letter for the name i
> want
> so that it go straight to the name or the list of names begining with the
> letter so i can select the name i want instead of scrolling down the list
> .
> its much quicker
> --
> help a friend help you