In the dialog, set allow to.
How to create a group drop down list in excel. Web type the list items in a table or convert an existing range to a table using the ctrl + t shortcut. On the data tab, in the data tools group, click data validation. You can rearrange your items as you please, but you’ll need to update the.
Go to the data tab. 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.
Back on the first sheet, select the blank cell to the right of the first label. Web select a cell or range of cells where you want to create the drop down list. Web for example, in cell c2, the data validation formula would be:
Within the data tools command group, select the data validation icon. This places the cells in a group so that you can name the group. Web select the topmost cell in which you want the primary dropdown list to appear (b3 in our case).
Web list the items for the dependent list, and then select the cells. =indirect (substitute (a2&b2, ,)) where a2 and b2 contain the first and second dropdowns,. Select the entire data set (a1:b6 in this example).
Select the cell (s) where you wish to insert a dropdown. In the data validation dialog. Web select a cell in which you want the dropdown to appear (d3 in our case).