This places the cells in a group so that you can name the group.

How to create a drop down list in excel with hyperlinks. Web get free advanced excel exercises with solutions! Web download the featured file here: This allows you to enter data into a specific cell of a.

In cell b2, enter the formula as below: Back on the first sheet, select the blank cell to the right of the first label. Web enter =age in the “source” box (if you named your cell range something else, replace “age” with that name).

Enter a name, for example choices, and press enter. This is already built into excel. On the ribbon, click the data tab, and click data validation.

In cell d2 is the following formula: Web 2 answers sorted by: Select the cells that you want to contain the lists.

With the cells selected, go up to the. Web select this range, then click in the name box on the left hand side of the formula bar. Web here is an option of how you could do it:

In cell c2 there is a data validation dropdown that points to a1:a3. Let's say that the cell.