Drop Down Boxes for Validation Cells are Too Wide

G

Geoff

For some reason, in some columns of my spreadsheet the validation drop
down boxes are too wide for the cell. In column A, for example, they
will be the width of the cell plus the dropdown arrow - perfect. In
column C they will exceed the width of the cell plus the drop down
arrow.

How do I fix this?
 
D

Debra Dalgleish

Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
validation).

To get rid of them, you may have to delete the row or column and
recreate the data validation.
 

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

Validation drop down box too large 5
LIST BOXES TOO WIDE 4
Data Validation Error 1
Data validation drop-down box 1
Validation drop down arrow list disappeared 2
Missing Drop Down list -Data Validation 5
How to delete a drop down box in Excel 2007 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top