With the cells selected, go up to the.

How to create a group drop down list in excel. Web select the rows you want to group and go to the data tab. Web list the items for the dependent list, and then select the cells. This places the cells in a group so that you can name the group.

Web type the list items in a table or convert an existing range to a table using the ctrl + t shortcut. Web select a cell in which you want the dropdown to appear (d3 in our case). Web add an item to a cell range to add a list item, simply enter it below the existing items.

Web this will create the drop down 1. Web select the topmost cell in which you want the primary dropdown list to appear (b3 in our case). In the data validation dialog.

Select the cells that you want to contain the lists. Web for example, in cell c2, the data validation formula would be: On the ribbon, click the data tab, and click data validation.

In the dialog, set allow to. Select the entire data set (a1:b6 in this example). You can rearrange your items as you please, but you’ll need to update the.

Web select a cell or range of cells where you want to create the drop down list. On the data tab, in the data tools group, click data validation. =indirect (substitute (a2&b2, ,)) where a2 and b2 contain the first and second dropdowns,.