To add the drop-down list in our example to an Excel cell, do the following: Select D2 to follow the example, but you can put the drop-down anywhere. Click the Data tab and then click Data ...

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 edit a drop-down list in Excel based on a cell range 1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.