#1   Report Post  
Posted to microsoft.public.excel.misc
ernie
 
Posts: n/a
Default Drop Down List

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
  #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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating worksheet via a drop down list ! kuansheng Excel Worksheet Functions 4 February 14th 06 05:48 AM
How do I make other cells dependent on my drop down list? mae1778 Excel Discussion (Misc queries) 1 July 29th 05 04:25 PM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
Pull unique names for drop down list [email protected] Excel Discussion (Misc queries) 3 February 1st 05 10:23 PM
Drop List Referencing Boony Excel Worksheet Functions 2 November 11th 04 11:42 AM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"