| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation "List" - Setting length of list shown
I am using a data validation that covers 26 rows of a list. When you click
the cell with the drop down, only 8 items of the 26 show. You have to use the scroll bar on the right side of the drop down to see the remaining items. Is there a way to set the DV/drop down to show all 26 items when you click the arrow? I appreciate any help. Thanks Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation "List" - Setting length of list shown
Not using data|validation.
Dave wrote: I am using a data validation that covers 26 rows of a list. When you click the cell with the drop down, only 8 items of the 26 show. You have to use the scroll bar on the right side of the drop down to see the remaining items. Is there a way to set the DV/drop down to show all 26 items when you click the arrow? I appreciate any help. Thanks Dave -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation "List" - Setting length of list shown
You can use a combo box from either the Forms toolbar or the Control toolbox
and set the number of items displayed. -- Biff Microsoft Excel MVP "Dave" wrote in message ... I am using a data validation that covers 26 rows of a list. When you click the cell with the drop down, only 8 items of the 26 show. You have to use the scroll bar on the right side of the drop down to see the remaining items. Is there a way to set the DV/drop down to show all 26 items when you click the arrow? I appreciate any help. Thanks Dave |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation "List" - Setting length of list shown
Thanks.
"Dave Peterson" wrote: Not using data|validation. Dave wrote: I am using a data validation that covers 26 rows of a list. When you click the cell with the drop down, only 8 items of the 26 show. You have to use the scroll bar on the right side of the drop down to see the remaining items. Is there a way to set the DV/drop down to show all 26 items when you click the arrow? I appreciate any help. Thanks Dave -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
| How Do I Get Out Of "DATA" ~ "CREATE LIST"? | Excel Discussion (Misc queries) | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| Data Validation - List - Data "NOT BETWEEN" - Source Possible? | Excel Worksheet Functions | |||
| Data Validation List Length | Excel Worksheet Functions | |||
Linear Mode
