Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using validation to make data appear or not | Excel Worksheet Functions | |||
How do I Make a drop-down box longer | Excel Discussion (Misc queries) | |||
make footer longer | Excel Discussion (Misc queries) | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Data Validation or Pull Down Menu | Excel Programming |