Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation list - Lengthen ? Posible ?
Can you length the amount of values visible from a validation list?
How? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation list - Lengthen ? Posible ?
No, it's fixed to max 8 visible entries in the drop down box. For the rest
you'll have to scroll. "Corey" wrote in message ... Can you length the amount of values visible from a validation list? How? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation list - Lengthen ? Posible ?
Hi Corey,
This may help you get to your selection quicker in your drop down list if it is quite long. Sort the list and then at the beginning of the A's enter a single A. Do the same for all the other letters on down the list, B, C etc. to Z. Now when you want to select something from the list, type the leading letter in the validation cell and DO NOT hit enter, the cell will still be in the edit mode with the cursor blinking. Click the drop down arrow and you will be at the top of that letters list. Now scroll down to your choice. You really can hit enter when you type in the letter but you will have to reselect the cell which is another step. (You can probably omit the A on top of the A list, it will appear first anyway if no letter is typed in.) HTH Regards, Howard "Corey" wrote in message ... Can you length the amount of values visible from a validation list? How? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Data Validation for list in a different workbook | Excel Discussion (Misc queries) | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |