Excel drop-down list alternative

1. How to make drop-down list in Excel without Data Validation?

How to make drop-down list in Excel without Data Validation?

Instead of using data validation, you could use a Form Control Combo Box. It gives you a bit more control over the appearance of the drop down list. You can adjust the number of drop down lines in the Form Control Combo box, so you can show all 12 months, without a scroll bar.