How do I Make a drop-down box longer

[Inspectec Rich]

I have several cells in a sheet assigned to show a list of info using the
"Validation" "List" options.
When you click on the cell a dropdown list appears of info to choose from.
It works fine but........
It only showns 8 lines. Then you have to scroll the drop-down list.
How do I make it longer, showing prehaps 15 or 20 lines so I do not have to
scroll in the dropdown?

Rich / Thank you!

 

[Pete_UK]

Debra Dalgleish has some techniques here:

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

Hope this helps.

Pete

 

[Debra Dalgleish]

I think Pete meant to use this link <g>:

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

It contains a link to instructions for using a combo box. With a combo
box, you can change the list length.