resize drop-down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Validation property of several cells is set to "list" and "drop-down", where
there are a LOT of options on the drop-down menu.

Is it possible to increase the size of the mini-window that opens when the
drop-down menu is activated, so that more options are shown at the same time?
 
You can't change the number of items visible in the data validation
dropdown. If you can use programming, there are instructions here for
using a combobox to overlay a cell with data validation:

http://www.contextures.com/xlDataVal11.html

In the combobox, you can change the ListRows property
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi layered drop down 1
Filtered drop down list 2
how to display the drop down menu icon? 1
Creating drop downs in a cell contingent on another drop down 1
Copying a Drop Down Menu 2
Lock Drop down Menu 2
Drop Down Menu 4
Select drop down menu option using libre-calc macro 0

Back
Top