Excel Hyperlinks To Cell or Range
In this article I will explain how you can create hyperlinks in Excel that will take the user to another location in the workbook. For example lets say we have the following data in sheet1:
When the user selects each item, we want the user to be taken to a specific cell:
- When the user selects item 1, we want the user to be taken to the cell H8 in sheet2.
- When the user selects item 2, we want the user to be taken to the cell N8 in sheet2.
- When the user selects item 3, we want the user to be taken to the cell H8 in sheet3.
- When the user selects item 4, we want the user to be taken to the cell N8 in sheet3.
The first thing to do is to create named ranges in the target locations:
Step 1: Go to Sheet2 select cell H8 and click on the Name Manager button from the Formulas ribbon:
Step 2: On the window that opens click on the new button:
Step 3: Select a name for the named range and click on OK:
Step 4: Do the same for the cell N8 in sheet2 and the cells H8 and N8 in sheet3.
Step 5: Return to sheet 1, click on Item 1 and click on the Hyperlink button in the Insert ribbon:
Step 6: Choose “Place in This Document”, then select the named range associated with the item. Repeat this for the other 3 items:
Result: Now by clicking each item you will be taken to the associated cell:
You can download the file related to this article from the link below:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com