Web there is no direct way to create drop down list with activated hyperlinks in excel, but, you can insert a formula to activate the selected hyperlink from the drop down list, please.

How to create linked drop down list in excel. Web on the ribbon, click data > data validation. In the dialog, set allow to list. Web select a cell in which you want the dropdown to appear (d3 in our case).

Select the cells that you want to contain the lists. In the dialog, set allow to. And then, insert the vba.

First, you make a regular data validation list in one or more cells. Enter a name, for example choices, and press enter. Web this will create the drop down 1.

Web with the cells selected, go up to the name box on the left side of the formula bar and enter a name for the cell group. Web select this range, then click in the name box on the left hand side of the formula bar. On the ribbon, click the data tab, and click data validation.

Place the cursor in the. Then, customize the list using the data validation options. Let's say that the cell.

Select the entire data set (a1:b6 in this example). On the data tab, in the data tools group, click data validation. You can add or delete items from your drop.