Help with drop-down list (2003)

S

seantera

Is there any way to control how the dropdown list is displayed?
Specifically, I have a data validation list in a cell. The column it is
in is only 4 units wide, with the text aligned at 90 degrees
(vertically). The dropdown list displayed is also only 4 units wide,
and does not show enough characters of each list item. I've seen other
spreadsheets where the dropdown list is wider than the column, but it
seems to be somewhat random...

Is there any way to increase the size (or other properties) of the
dropdown list (apart from increasing the column width)?
 
S

seantera

thank you for responding, the problem is on one of the sheets the dro
down is bigger than the cell and after I copy the sheet and use th
drop down box a couple of times it shrinks up
 
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.
 
Top