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).

--
Rick (MVP - Excel)


"Stunzer via OfficeKB.com" <u53932@uwe wrote in message
news:9a8b235fa2492@uwe...
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?

--
Message posted via http://www.officekb.com