Drop Down Boxes for Validation Cells are Too Wide

  • Thread starter Thread starter Geoff
  • Start date Start date
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?
 
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
Data validation drop-down box 1
Drop Box Width 3
Data Validation Error 1
LIST BOXES TOO WIDE 4
Validation drop down arrow list disappeared 2
drop down box 1
How do I make the drop-down portion of a list wider than the cell? 2

Back
Top