Drop down list for Data Validation

  • Thread starter Thread starter jlbreyer
  • Start date Start date
J

jlbreyer

In Data Validation using a list, is there a way to
specify how many items show in the drop down list? I'm
using Office 2003 and my drop down list only shows eight
(8) items. I want twenty.
jlb
 
If you can use macros, there's a sample file here that provides a
combobox from which you can select one of the values. In a combobox, you
can set the number of rows in the dropdown list:

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

Under 'Data Validation', look for 'Data Validation Combobox'
 
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

Drop down list 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation drop-down 5
Filtered drop down list 2
Data Validation List (Drop Down) Not Showing 2
Size of drop down in validation list 2
Drop down list 2
Data Validation 3

Back
Top