Drop Down Boxes for Validation Cells are Too Wide

[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?

 

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