Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name).

How to create drop down list in excel with multiple choices. If you don't want users to. Set up the first drop down the main dropdown list is created with exact. On the ribbon, click the data tab, and click data validation.

On the web, there are many questions about how. Web list the items for the dependent list, and then select the cells. Back on the first sheet, select the blank cell to the right of the first label.

Web go to the data tab and click on data validation in the data tools group. Go to the data tab and click on data validation. Select the list in allow option in validation criteria.

Web with the two named formulas in place, you set up data validation in the usual way ( data tab > data validation ). Web to make a multiple dependent drop down list in excel, this is what you need to do: Web many excel users tend to create drop down list with multiple checkboxes in order to select multiple items from the list per time.

In the dialog, set allow to. Actually, you can’t create a list with. This places the cells in a group so that you can name the group.