size of data validation dropdown list

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

Guest

Hi All,

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?

Thanks,
Stefi
 
Hi Stefi

The list size in Data Validation is fixed at 8.
If you want to alter the number, you would need to change to a Combo Box
instead.
For more information on setting up a Combo box for the purpose take a look
at Debra Dalgleish's site
http://www.contextures.com/xlDataVal10.html

Regards

Roger Govier
 

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

Dependent dropdowns 4
In excell 2003, increasing number of items shown in drop down list 1
Creating Data Validation Dependent Lists 2
Data Validation List Length 4
Dynamically load DataValidation List through Source field? 1
Unique/Distinct Dropdown List 10
Formula in dropdown list 2
using autofilter data 2

Back
Top