Validation drop-down lists:increase the default length

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.