How To Create Dynamic Hyperlink To Another Sheet In Excel?

Excel is a powerful tool that offers various functionalities to its users. One such feature is the ability to create hyperlinks between sheets, which can save time and effort while navigating through large workbooks. Hyperlinks allow users to jump from one sheet to another within a workbook or to an external file, website or email address. However, not all hyperlinks are created equal. Dynamic hyperlinks, in particular, are especially useful because they can adapt to changes in the target sheet's location, name, or content.

In this tutorial, we will guide you step-by-step on how to create dynamic hyperlinks to another sheet in Excel. We will cover the basics of creating hyperlinks, then move on to the more advanced topic of creating dynamic hyperlinks that can be updated automatically. Whether you're a beginner or an advanced Excel user, this tutorial will help you create efficient and effective hyperlinks in your workbooks. So, let's get started!

Create Dynamic Hyperlink To Another Sheet

Here, we will first name the cell using the name box, then create a hyperlink to complete the task. So let us see a simple process to know how you can create a dynamic hyperlink to another sheet in Excel.

Step 1

Consider any excel sheet where you have a list of names as similar to the below image.

First, in the source sheet, select the range of cells, click on the name box, name them MyList and click enter.

Select cells > Name box > Name > Enter.

Step 2

In another sheet, click on an empty cell, in our case cell B1, and enter the formula as =HYPERLINK("#MyList","Click Here") and click enter to complete our task.


In this tutorial, we have used a simple example to demonstrate how you can create a dynamic hyperlink to another sheet in Excel to highlight a particular set of data.

Updated on: 13-Jul-2023


Kickstart Your Career

Get certified by completing the course

Get Started