It shows the 2 ways you can do that in excel using formulas and vba.

How to add drop down list in excel developer. Extract data based on a drop down list selection in excel; On the ribbon, click the data tab, and click data validation. If the item you want to delete is somewhere in the middle of your list, right.

You can add or delete items from your drop. Enter a name, for example choices, and press enter. Web to add an item, go to the end of the list and type the new item.

Then, customize the list using the data validation options. Select the data tools group from the data tab. Let's say that the cell.

In the data validation dialog. Web select this range, then click in the name box on the left hand side of the formula bar. Web how to create dependent drop down list with multiple words in excel;

Web select a cell in which you want the dropdown to appear (d3 in our case). Select the cells that you want to contain the lists. On the data tab, in the data tools group, click data validation.