How To Create Drop Down List With Hyperlinks In Excel?

Excel is a powerful tool that allows you to organize and analyze data in a variety of ways. One feature that can be particularly useful is the ability to create drop down lists with hyperlinks. This feature can save you time and effort by allowing you to quickly navigate to important information without having to search for it manually.

In this tutorial, we will guide you through the process of creating a drop down list with hyperlinks in Excel. Whether you need to create a navigation menu for a spreadsheet, or you simply want to make it easier to access important information, this tutorial will show you how to get started. We will provide step-by-step instructions, along with helpful tips and tricks to ensure that you can create a drop down list with hyperlinks with ease. So, let's get started!

Create Drop Down List With Hyperlinks

Here we will first name the range of cells and a single cell, then use the form controls combo box to complete the task. So let us see a simple process to know how you can create drop-down lists with hyperlinks in Excel.

Step 1

Consider an Excel sheet where you have a list of hyperlinks similar to the below image.

First, select the range of cells, click on the name box, name them lists, and click enter.

Select cells > Name Box > Name > Enter.

Step 2

Now again, click on an empty cell, name the cells cell, and click enter.

Empty cell > Name > Enter.

Step 3

Then click on developer, then click on insert, select the form control combo box, and draw the box.

Developer > Insert > Combo box > Draw.

Step 4

Now right-click on the box and select Format Control, click on Control, enter the input range as links and the cell link as cells, and click OK.

Right click > Format control > Control > Input > Cell link > Ok.

Step 5

Finally, right-click on the box and select Assign Macro; click on New; and copy the below-mentioned code into the text box as shown below.

Right click > Assign Macro > New > Copy code.

Code

Sub DropDown2_Change()
HyperLink_Index = Range("Cells")
   If Range("Links").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
      Range("Links").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
   End If
End Sub

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can create a drop-down list with hyperlinks in Excel to highlight a particular set of data.