| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Resize a data valication drop down box?
I have a large number of variables that I display in a drop down from a data
validation list. The shorter lists display fine. The longer lists automatically provide the scroll bar. All of that is great. I have a couple of lists that could be displayed without the scroll bars if I was able to incrase the length of the drop down box. How can I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Resize a data valication drop down box?
In short you can't increase the size...
-- HTH... Jim Thomlinson "Dave" wrote: I have a large number of variables that I display in a drop down from a data validation list. The shorter lists display fine. The longer lists automatically provide the scroll bar. All of that is great. I have a couple of lists that could be displayed without the scroll bars if I was able to incrase the length of the drop down box. How can I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Resize a data valication drop down box?
DV list dropdowns cannot be re-sized
You could try a ComboBox instead. Gord Dibben MS Excel MVP On Fri, 8 Aug 2008 08:03:02 -0700, Dave wrote: I have a large number of variables that I display in a drop down from a data validation list. The shorter lists display fine. The longer lists automatically provide the scroll bar. All of that is great. I have a couple of lists that could be displayed without the scroll bars if I was able to incrase the length of the drop down box. How can I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resize Data Labels | Excel Discussion (Misc queries) | |||
| I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
| resize drop-down menu | Excel Discussion (Misc queries) | |||
| I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
| How do you resize the font in a drop-down menu? | Excel Discussion (Misc queries) | |||
Linear Mode
