Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Now, right-click the spin button, choose Format Control, and click the Control tab to configure the control. The ‘Current value’ is the starting value for the control. The ‘Minimum value ...