You can't make the list longer than the default of 8 rows. If you can
use programming, there's a workaround suggested he

http://www.contextures.com/xlDataVal08.html#Font

Inspector wrote:
Actually I'd like to make the box itself longer. I think it is 6 or 7 cells
long now and I would like to make it 12 cells long. I would like to see all
of the choices to avoid scrolling.

"Debra Dalgleish" wrote:


You can't make the font larger, but there are a couple of workarounds he

http://www.contextures.com/xlDataVal08.html#Larger

To make the list appear wider, you can use the following technique:

http://www.contextures.com/xlDataVal08.html#Wider


Inspector wrote:

I have inserted a drop down box through Data, Validation, List. Is the box a
pre-defined size or can I change it? If I can change the size of it, how do
I do it?
Thank you


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html