Extend length of drop down list question

[ipbr21054]

Morning,
I have a drop down list on my worksheet in cells on column A
I have 9 available options to select from within the list.
Once you click the drop down arrow i see 8 items & have to click the slider & drag down to be able to select the last item.

How is it possible to make this box etc longer so all the selectable options are shown without haveing to click & drag the slider down..

Thanks

 

[Jeffrey Mahoney]

Nope. In-cell dropdown lists are not resizable. You can add ActiveX combo boxes or list boxes. Those get tedious to manage if there more than a dozen or so.

 

[ipbr21054]

Ok thanks very much