How to Hyperlink Multiple Cells in Excel (3 Ways)

In Microsoft Excel, hyperlinks are used as a link to certain web pages. It can also be a handy tool to link another file, Excel sheet, or cell. By clicking hyperlinks we can easily jump to another location in Excel. In this article, we will see How to Hyperlink Multiple Cells in Excel. We will use a sample dataset for your better understanding containing Excel-related Topics and Web addresses.

How to hyperlink multiple cells in excel


Download Practice Workbook


3 Ways to Hyperlink Multiple Cells in Excel

In this post, we will guide you through 3 different methods using the Hyperlink function and INSERT options to create hyperlinks in multiple cells in Excel.


Method 1: Hyperlink Multiple Cells in Excel Using Function

Using the HYPERLINK function we can easily create hyperlinks in Excel. As you can see, we have a dataset containing lengthy web addresses, we will link the addresses according to their topic name.

Steps:

  • First, type the following formula in Cell D5.
=HYPERLINK(C5,B5)

How to hyperlink multiple cell in excel using Hyperlink Function

  • After that, press the ENTER key.

How to hyperlink multiple cell in excel using Hyperlink Function

  • Finally, drag down to AutoFill rest of the series.

How to hyperlink multiple cell in excel using Hyperlink Function

Here, we are creating hyperlinks for all these web links according to their topic name. You can see that the topic names are visible in the linked cells.

Read More: How to Hyperlink Multiple PDF Files in Excel (3 Methods)


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

In this method, we will see, how to create hyperlinks for files and cells in Excel.

Steps:

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

How to hyperlink multiple cell in excel using menu

  • Now, we can select any file, image, existing Excel file, Powerpoint, etc. from the dialogue box.

How to hyperlink multiple cell in excel using shortcut

  • As you can see from the image below, we have selected an Excel file and renamed it in the Text to display box.

  • After clicking OK, we will get the hyperlink as follow, and clicking this link will automatically open the linked file.

  • If we want to create web links, just press CTRL+K and do the following as shown in the image.

How to hyperlink multiple cell in excel using shortcut

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

  • If we want to link this to some random cell in Excel, just do the following after pressing CTRL+K.

  •  Now, the cell will look like the following image.

How to hyperlink multiple cells in excel by shortcut

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.

  • At first, press CTRL+K and we have to do the following.

How to hyperlink multiple cell in excel using shortcut for rancom cells

  • Here, we selected the Sample Dataset sheet. Finally, our dataset will look like the following image.

How to hyperlink multiple cells in excel by shortcut

  • Clicking on this hyperlink will take us to the topic name range in the sample dataset of this Excel workbook file.

Read More: How to Activate Multiple Hyperlinks in Excel (4 Ways)


Similar Readings


Method 3: Create Hyperlink for Cell Range Using Name Range

Now, we will see the use of the Defined Names in this method.

Steps:

  • First, select the range and go to Formulas > Defined Names.

How to hyperlink multiple cells in excel by defined name

  • As a result, a dialogue box will pop up and we will define the range name.

  • Now, select the cell where we want to insert a hyperlink and press CTRL+K.

  • From here, just select the name we just defined.

How to hyperlink multiple cells in excel by Formula bar

  • After clicking OK, we will get the following result.

How to hyperlink multiple cells in excel

  • Now, if you click the link, it will take you to the location where the multiple cells are hyperlinked.

Read More: How to Create a Hyperlink in Excel (5 Easy Ways)


Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.

How to hyperlink multiple cells in excel practice


Conclusion

That’s all for the article. These are 3 different methods for How to Hyperlink Multiple Cells in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.


Related Articles

Mahbub
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo