How to add a combo box in Excel The first step is to embed a combo box and populate it with a unique list of category values so we can take advantage of its autocomplete behavior.

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.

This is where the auto-complete entry will appear. Click "OK" to apply the formatting and add the combo box to your worksheet.

You can also populate the combo box with items from a list model by dragging the model from the Components window onto the combo box in the frame. Finally, you can specify the values of the items in ...