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

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

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

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.

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.