Monday, June 18, 2012

How to Use Hyperlinks in Dropdown Menus in Excel


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
5. Choose a menu cell, for example, cell B6.
6. Insert the following function into cell C6 (the cell below the chosen menu cell):=HYPERLINK(B6, 'Goto Link')
7. Change 'GoTo Link' to your choice of text.

Blogger news