Extend length of drop down list question

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,789
Office Version
  1. 2007
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,823
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,134
Messages
5,570,364
Members
412,320
Latest member
sixnine0312
Top