How to Hyperlink Multiple Cells in Excel (3 Ways)

In this article, we will describe how to hyperlink multiple cells in Excel using 3 different methods. We’ll use the following sample dataset containing Excel-related topics and web addresses to demonstrate our methods.

Method 1 – Hyperlink Multiple Cells Using the Hyperlink Function

Using the HYPERLINK function we can easily create hyperlinks in Excel. Our dataset contains lengthy web addresses, so let’s link the addresses according to their topic name.

Steps:

Enter the following formula in Cell D5:

=HYPERLINK(C5,B5)

Press ENTER.

Drag down the Fill Handle to AutoFill rest of the series.

Hyperlinks are created for all the web links using their topic names as titles.

Read More: How to Create a Hyperlink in Excel

Method 2 – Hyperlink Links, Files, and Addresses in Excel

In addition to websites, we can also create hyperlinks for files and cells in Excel.

Steps:

Click on cell C5 and press CTRL+K, or go to INSERT > Hyperlink.

Select any file, image, existing Excel file, Powerpoint etc. in the dialog box.

Here, we have selected an Excel file and renamed it in the Text to display box.

Click OK.

. A hyperlink to the file is created. Clicking this link will automatically open the linked file.

To create web links, press CTRL+K and do the following:

Here, we have created a link for our website exceldemy.com.

To link to a cell in Excel, do the following after pressing CTRL+K:

The cell will look like the following image.

Now, we will create a hyperlink for different sheets. Suppose, we want to create a hyperlink that will take us to the location of topics in our Excel sheet.