View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SlowDriver
 
Posts: n/a
Default How to extend the no' of displayed entries in a drop down list

I have created a drop down list in a speadsheet which references a long list
on another sheet.
Only a part of the list displays in the drop down. I need to scroll down to
see the rest. They are all there. How do I set the size of the drop down box
to display all the valid options.