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:
Other People Are Reading
Access editing capabilities by double-clicking the cell in the menu that contains the URL that you would like to hyperlink.
Activate the URL by pressing "Enter." This will convert the text URL to an active hyperlink.
Click that now-active hyperlink one more time to complete the process.
Repeat Steps 1 through 3 for each menu item.
Choose a menu cell, for example, cell B6.
Insert the following function into cell C6 (the cell below the chosen menu cell):
=HYPERLINK(B6, "Goto Link")
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for