Dropdown List - list item endings not visible if column too narrow

[Guest]

Hi,
I've created a drop-down list using the Data > Validation function. When I
went to use the dropdown list, I noticed I couldn't see the endings of some
of the longer list items because the column was too narrow. If I made the
column wider I could see the ending.

Is there a simple way of increasing the width of a drop-down list (so I can
see the list item endings) without increasing the column width. I need to fit
quite a number of columns on a page, so making the columns the same width as
the longest list item is not an option.
Thanks AK

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal08.html#Wider

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob, I've learnt something new today. Worked woohoo!