How to Create a Dynamic Hyperlink in Excel

- Written by Puneet

excelchamps-free-courses-puneet-gogia

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.

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

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.

Get the Excel File

Last Updated: December 02, 2023

Leave a Comment