size of data validation dropdown list

S

Stefi

Hi All,

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?

Thanks,
Stefi
 
R

Roger Govier

Hi Stefi

The list size in Data Validation is fixed at 8.
If you want to alter the number, you would need to change to a Combo Box
instead.
For more information on setting up a Combo box for the purpose take a look
at Debra Dalgleish's site
http://www.contextures.com/xlDataVal10.html

Regards

Roger Govier
 
Top