Drop down list for Data Validation

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
 
D

Debra Dalgleish

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'
 
Top