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.