How to Insert a Combo Box in Excel 2010. Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box ...

How to Use Auto Complete in a Combo Box in Excel 2003. Excel offers tools and characteristics that make it an ideal platform for you to create data entry forms.

To create a drop-down list, select cell where you want it to be (in this case, cell I2), and in the Data tab on the ribbon, click "Data Validation" in the drop-down option with the same name.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.