Create a Dynamic Hyperlink

To create a dynamic hyperlink where you can change the link that you have specified, you need to use Excel’s HYPERLINK function. This function allows you to specify a link to a web address or cell in the workbook.

create-dynamic-hyperlink

In this tutorial, we will learn to write a formula for this.

Write a Formula to Create a Dynamic Hyperlink (Web Address)

You can use the below steps for this.

  1. First, enter the HYPERLINK function in a cell.
  2. After that, in the first argument, refer to the cell where you are going to update the hyperlink address, Let’s say cell B1.
  3. Next, in the second argument, enter a friendly name for the link to how in the link.
  4. In the end, enter the closing parentheses and hit enter.
formula-to-create-dynamic-hyperlink
=HYPERLINK(B1,"Hello")

In cell B1, we have a drop-down list to change the web address. And the moment you change the link address in cell B1, it will also change the link in the formula.

drop-down-list-to-change-web-address

Create a Dynamic Hyperlink for a Cell Address

In the same way, you can create a dynamic hyperlink for a cell in the workbook.

dynamic-hyperlink-for-a-cell-address
=HYPERLINK("#"&B1,"Hello")

In the above formula, we have used the “#” with a combination of the cell reference of cell B1. Now, as soon as you change the cell address in cell B1 it changes the link in the formula.

Download Sample File