View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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