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:

HyperLink excel, Data in Sheet 1
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:

Sheet2 Named Range
Step 2: On the window that opens click on the new button:

New Named Range
Step 3: Select a name for the named range and click on OK:

Select Name and Click Ok

Step 4: Do the same for the cell N8 in sheet2 and the cells H8 and N8 in sheet3.

Named Ranges, Excel, HyperLink
Step 5: Return to sheet 1, click on Item 1 and click on the Hyperlink button in the Insert ribbon:

Insert Hyper Link
Step 6: Choose “Place in This Document”, then select the named range associated with the item. Repeat this for the other 3 items:

Excel, Hyperlink, Insert
Result: Now by clicking each item you will be taken to the associated cell:

Excel Hyperlinks
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

Leave a Reply

Your email address will not be published.