So I made a named range and then made a drop down list of it using the data>validity tool. However, my list has about 20 different options in the list but I click that drop down list open I get a tiny drop down list that shows maybe 8 of them so I need to constantly scroll up and down and can’t see all of the options at once. Can the drop down list be made bigger so it shows all of the options? The width is fine but vertically the list is way too short and annoying to use.
Afaik you can’t - but you can click the drop down, start typing and the drop down scrolls to the first match
As workaround - use control ComboBox.
Set count of lines
Set target cell and source range
Get result
