| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Validation
I have inserted a drop down box through Data, Validation, List. Is the box a
pre-defined size or can I change it? If I can change the size of it, how do I do it? Thank you |
|
#2
|
|||
|
|||
|
You can't make the font larger, but there are a couple of workarounds he
http://www.contextures.com/xlDataVal08.html#Larger To make the list appear wider, you can use the following technique: http://www.contextures.com/xlDataVal08.html#Wider Inspector wrote: I have inserted a drop down box through Data, Validation, List. Is the box a pre-defined size or can I change it? If I can change the size of it, how do I do it? Thank you -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Actually I'd like to make the box itself longer. I think it is 6 or 7 cells
long now and I would like to make it 12 cells long. I would like to see all of the choices to avoid scrolling. "Debra Dalgleish" wrote: You can't make the font larger, but there are a couple of workarounds he http://www.contextures.com/xlDataVal08.html#Larger To make the list appear wider, you can use the following technique: http://www.contextures.com/xlDataVal08.html#Wider Inspector wrote: I have inserted a drop down box through Data, Validation, List. Is the box a pre-defined size or can I change it? If I can change the size of it, how do I do it? Thank you -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
Hi
this is AFAIK not possible -- Regards Frank Kabel Frankfurt, Germany Inspector wrote: Actually I'd like to make the box itself longer. I think it is 6 or 7 cells long now and I would like to make it 12 cells long. I would like to see all of the choices to avoid scrolling. "Debra Dalgleish" wrote: You can't make the font larger, but there are a couple of workarounds he http://www.contextures.com/xlDataVal08.html#Larger To make the list appear wider, you can use the following technique: http://www.contextures.com/xlDataVal08.html#Wider Inspector wrote: I have inserted a drop down box through Data, Validation, List. Is the box a pre-defined size or can I change it? If I can change the size of it, how do I do it? Thank you -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#5
|
|||
|
|||
|
You can't make the list longer than the default of 8 rows. If you can
use programming, there's a workaround suggested he http://www.contextures.com/xlDataVal08.html#Font Inspector wrote: Actually I'd like to make the box itself longer. I think it is 6 or 7 cells long now and I would like to make it 12 cells long. I would like to see all of the choices to avoid scrolling. "Debra Dalgleish" wrote: You can't make the font larger, but there are a couple of workarounds he http://www.contextures.com/xlDataVal08.html#Larger To make the list appear wider, you can use the following technique: http://www.contextures.com/xlDataVal08.html#Wider Inspector wrote: I have inserted a drop down box through Data, Validation, List. Is the box a pre-defined size or can I change it? If I can change the size of it, how do I do it? Thank you -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| list validation using list validation... | Excel Worksheet Functions | |||
| Validation list behaving strangely in 2003 | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Worksheet Functions | |||
Linear Mode
