How to Use Hyperlinks in Dropdown Menus in Excel

Written by kim sarah
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Hyperlinks in Dropdown Menus in Excel
Links can be added to Excel drop-down menus containing URLs. (keyboard image by red 2000 from Fotolia.com)

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.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

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

  2. 2

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

  3. 3

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

  4. 4

    Repeat Steps 1 through 3 for each menu item.

  1. 1

    Choose a menu cell, for example, cell B6.

  2. 2

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

    =HYPERLINK(B6, "Goto Link")

  3. 3

    Change "GoTo Link" to your choice of text.

Tips and warnings

  • Pay attention to links in the alternate method that are displayed using regular text rather than the URL. Since the URL is not visible, creating a bad link can be an easy mistake.
  • Too many drop-down menus and links can make an Excel spreadsheet appear cluttered and confusing.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.