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

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

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

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)

"AK9955" wrote in message
...
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

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

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

"Bob Phillips" wrote:

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)

"AK9955" wrote in message
...
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