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.

Type the cell that you want the combo box linked to into the "Cell Link" box, such as "F2." This is where the auto-complete entry will appear. Click "OK" to apply the formatting and add the combo ...

Now, add a combo box control near cell B2 as follows: Click the Developer tab. In the Control group, click the Insert dropdown and then choose Combo Box from the ActiveX Controls section.