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?

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

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