Sizing drop down validation box

  • Thread starter Thread starter Wayman Bell
  • Start date Start date
W

Wayman Bell

I have a form with lots of drop down validation boxes, many of them are
Yes,No,N/A or Pass,Fail,N/A so one a narrow box is required but all the drop
downs are about three inches wide. Once I accidentally go them to the right
size and saved the file, closed it, then re-opened and the drop downs were
really wide again.

Does anyone know have to set the width, I always thought they were the same
width as the cell they pop from but not the case.

Wayman
 
Those 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.
 
Thanks Debra,

I will keep tying then. I knew that the drop downs in the tool bar could be
re-sized so I was hoping there was a way to set the ones in a spreadsheet.

Wayman
 
Back
Top