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 |
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 |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com