How to Use Hyperlinks in Dropdown Menus in Excel

Microsoft Excel is software that allows for the creation of spreadsheets. Using cells ordered horizontally by numbers and vertically by letters, this program has the ability to calculate engineering, financial and statistical problems.



Menus can be created in an Excel cell. A drop-down menu is one option. When clicked, this menu will expand downward to display all of the values, words or URLs that have been entered. These displayed options can be converted to hyperlinks to connect the user to a website.

Adding Links to Drop-down Menus

• 1

  Access editing capabilities by double-clicking the cell in the menu that contains the URL that you would like to hyperlink.

• 2

  Activate the URL by pressing "Enter." This will convert the text URL to an active hyperlink.

• 3

  Click that now-active hyperlink one more time to complete the process.

• 4

  Repeat Steps 1 through 3 for each menu item.

Alternate Method

• 1

  Choose a menu cell, for example, cell B6.

• 2

  Insert the following function into cell C6 (the cell below the chosen menu cell):

  =HYPERLINK(B6, "Goto Link")

• 3

  Change "GoTo Link" to your choice of text.