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

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

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

Hi!

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


"Stunzer via OfficeKB.com" wrote:

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

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

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