ExcelBanter - Validation drop-down lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Validation drop-down lists (https://www.excelbanter.com/excel-worksheet-functions/63317-validation-drop-down-lists.html)

Lee

Validation drop-down lists

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.

Chip Pearson

Validation drop-down lists

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.

All times are GMT +1. The time now is 06:43 PM.