Web 2 answers sorted by:

How to create a drop down list in excel with hyperlinks. Let's say that the cell. Back on the first sheet, select the blank cell to the right of the first label. This places the cells in a group so that you can name the group.

On the ribbon, click the data tab, and click data validation. In cell d2 is the following formula: Web download the featured file here:

Enter a name, for example choices, and press enter. In cell c2 there is a data validation dropdown that points to a1:a3. If you don't want users to.

Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name). In cell b2, enter the formula as below: Web get free advanced excel exercises with solutions!

This allows you to enter data into a specific cell of a. Web list the items for the dependent list, and then select the cells. Select the cells that you want to contain the lists.

Web here is an option of how you could do it: This is already built into excel.