Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I extend my drop-down box length to include all the list?
I am wanting to be able to select a list and see all the choices, not just
the default of the first eight. Any help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I extend my drop-down box length to include all the list?
Hi!
Use a combo box from the Forms toolbar. You can specify how many items to display in the list. Biff "sigeco" wrote in message ... I am wanting to be able to select a list and see all the choices, not just the default of the first eight. Any help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I extend my drop-down box length to include all the list?
You cannot extend a Data Validation drop-down above the 8 choices.
You can use a ComboBox of much greater height to get more in view. See Debra Dalgleish's site for info on this. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Mon, 19 Jun 2006 17:15:01 -0700, sigeco wrote: I am wanting to be able to select a list and see all the choices, not just the default of the first eight. Any help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I extend my drop-down box length to include all the li
Thanks, Biff!
I didn't think to use a combo box. It will work out fine :) sigeco "Biff" wrote: Hi! Use a combo box from the Forms toolbar. You can specify how many items to display in the list. Biff "sigeco" wrote in message ... I am wanting to be able to select a list and see all the choices, not just the default of the first eight. Any help? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I extend my drop-down box length to include all the li
You're welcome!
Biff "sigeco" wrote in message ... Thanks, Biff! I didn't think to use a combo box. It will work out fine :) sigeco "Biff" wrote: Hi! Use a combo box from the Forms toolbar. You can specify how many items to display in the list. Biff "sigeco" wrote in message ... I am wanting to be able to select a list and see all the choices, not just the default of the first eight. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional drop down list | Excel Discussion (Misc queries) | |||
drop down list of a drop down list | Excel Worksheet Functions | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |