View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Can I increase the view of a drop down list beyond 8 in Excel?

Not if you used data|validation.

dustinhess@jore wrote:

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?


--

Dave Peterson