How to Make a Drop Down Box to Allow ... Excel's Data Tools give you options to display a message as ... Click the "Settings" tab and click the "Clear All" button. Click "OK" to close the dialog box.

For example, if your list of combo box options is located between cells E2 and E10 or your worksheet, you would enter "E2:E10" into the Input Range box. Advertisement Article continues below this ad ...

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.