How do I adjust the size of the drop down list?

[Joy 13883]

I've added a lot of drop down lists within my document. The first sheet
works great, but all the other sheets has the drop down list extending over 2
or 3 of the columns when clicked on. Is there any way to adjust this?

 

[Frank Kabel]

Hi
waht kind of drop downs have you used?