Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data validation
I have created a data validation drop down list. When I open the dropdown box
Ii can not see the entire list and have to use the down/ up arrows to scroll through the list. Can i make the dropdown box bigger so I won't have to scroll? |
#2
|
|||
|
|||
The data validation dropdown is limited to 8 rows, and can't be changed.
If you can use macros, there's a sample file here that provides a combobox from which you can select one of the values. In a combobox, you can set the number of rows in the dropdown list: http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' Aferreira wrote: I have created a data validation drop down list. When I open the dropdown box Ii can not see the entire list and have to use the down/ up arrows to scroll through the list. Can i make the dropdown box bigger so I won't have to scroll? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks for your help
"Debra Dalgleish" wrote: The data validation dropdown is limited to 8 rows, and can't be changed. If you can use macros, there's a sample file here that provides a combobox from which you can select one of the values. In a combobox, you can set the number of rows in the dropdown list: http://www.contextures.com/excelfiles.html Under 'Data Validation', look for 'Data Validation Combobox' Aferreira wrote: I have created a data validation drop down list. When I open the dropdown box Ii can not see the entire list and have to use the down/ up arrows to scroll through the list. Can i make the dropdown box bigger so I won't have to scroll? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |