How to control drop down list width

D

DocBrown

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
 
J

jb_tenor1

I am also having this same problem. Looking forward to any advice. I have a
screenshot if you would like to see it.
 
G

Gord Dibben

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
 
J

jb_tenor1

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.
 
G

Gord Dibben

I'll take a look.

Change the AT and DOT in my email address and send to me.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Width of DV drop down list changes 1
Data Validation drop-down width, with named range source (XL03 and 4
Outlook meeting location auto prompts with a suggestion list - need to disable 0
resizing list width in combo box 0
Validation of cell based on Drop down list 1

Top