View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default LIST BOXES TOO WIDE

I created several drop down list boxes to limit entries in several fields in
a worksheet. Two fields are limited to "YES" and "NO." When I click on the
down arrow which makes the list pop up, it is a good 3-4" wide, with the YES
and NO at the far left of the box. It is quite annoying to have to move the
mouse so far to click the appropriate choice. Is there some way to limit the
width of the drop down box?

Thanks for ideas.
--
William