Thread: Drop Down List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle
 
Posts: n/a
Default Drop Down List

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" wrote in message
...
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