Extension of drop down list

[ipbr21054]

Evening,

On my worksheet a have a few drop down lists and wondering if its possible to make the list longer.
Example.
I have say 50 items in my list,when i click on the drop down arrow it only shows 10 of them and i need to scroll down before i can select.
It would be nice to just show say 30 etc.

Many thanks

 

[My Aswer Is This]

You can quickly go down list with up down arrow keys.
I know of no way to make list longer

 

[ipbr21054]

Thanks very much.
I did know that but looking to do it another way.

Cheers