Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |