No, you can't change the number of items in the dropdown list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lee" wrote in message
...
How do I increase the default length of a validation drop-down
list to more
than 8 lines? For example, to 12 for the months of the year.