Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to control drop down list width
This may be a bug... I have cells with validation set to a list. When I
display the list, the width of the list is much wider than the column. This does not happen for all my lists, just a couple. The width of the source list column is correct. There is no data in the list cells that should be making the data wide. It seems that the cell with the validation should be controllig the dropdown list width. Any Ideas what may be causing this? Thanks, John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to control drop down list width
I am also having this same problem. Looking forward to any advice. I have a
screenshot if you would like to see it. "DocBrown" wrote: This may be a bug... I have cells with validation set to a list. When I display the list, the width of the list is much wider than the column. This does not happen for all my lists, just a couple. The width of the source list column is correct. There is no data in the list cells that should be making the data wide. It seems that the cell with the validation should be controllig the dropdown list width. Any Ideas what may be causing this? Thanks, John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to control drop down list width
Only way I can replicate this is if I have merged a couple of cells and
placed my DV dropdown in that merged cell.. Gord Dibben MS Excel MVP On Tue, 17 Mar 2009 06:48:01 -0700, jb_tenor1 wrote: I am also having this same problem. Looking forward to any advice. I have a screenshot if you would like to see it. "DocBrown" wrote: This may be a bug... I have cells with validation set to a list. When I display the list, the width of the list is much wider than the column. This does not happen for all my lists, just a couple. The width of the source list column is correct. There is no data in the list cells that should be making the data wide. It seems that the cell with the validation should be controllig the dropdown list width. Any Ideas what may be causing this? Thanks, John |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to control drop down list width
Not in my case. I have the list in a single cell that has not been merged.
I can send it to you if you'd like to take a look. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to control drop down list width
I'll take a look.
Change the AT and DOT in my email address and send to me. Gord On Tue, 17 Mar 2009 09:23:01 -0700, jb_tenor1 wrote: Not in my case. I have the list in a single cell that has not been merged. I can send it to you if you'd like to take a look. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List Width? | Excel Discussion (Misc queries) | |||
Data-Validation-List-Width of list must be colomn width, is this possible | Excel Worksheet Functions | |||
Width of drop-down list | Excel Worksheet Functions | |||
Control Display of Drop Down List in Validation | Excel Worksheet Functions | |||
Drop down list box width - data validation | Excel Discussion (Misc queries) |