View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dustinhess@jore dustinhess@jore is offline
external usenet poster
 
Posts: 1
Default Can I increase the view of a drop down list beyond 8 in Excel?

I created a drop down list from a group of more than 8 items (12 items).
When the drop down list arrow is clicked, Excel shows the first eight than
has the block on the right hand side to scroll down the list. I would like
to see every item in the group at the same time. Is there a way to make my
view longer to include all 12 items?