Data Validation Pull-Down: How can I make it longer?

[Stunzer via OfficeKB.com]

I have created a pull-down with many different options(79 actually) and want
the pulldown to show more than the current 8(it's a long way to scroll down...
..).
Anyone know how to do this?

 

[Eduardo]

Hi!

Use a combo box from the Forms toolbar. You can specify how many items to
display in the list.

 

[Rick Rothstein]

I don't think you can lengthen the drop-down that Data/Validation provides;
but if you want to move through the list quickly, you can press
Alt+{DownArrow} to open the drop-down list and then repeatedly press the
PageDown key to move through the list (this can be done quite quickly and
may prove easier than scrolling the list with the mouse).