View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AK9955 AK9955 is offline
external usenet poster
 
Posts: 8
Default 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