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.
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)
- After that, press the ENTER key.
- Finally, drag down to AutoFill rest of the series.
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.
- Now, we can select any file, image, existing Excel file, Powerpoint, etc. from the dialogue box.
- 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.
- 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.
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.
- Here, we selected the Sample Dataset sheet. Finally, our dataset will look like the following image.
- 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
- [Fixed!] This Workbook Contains Links to One or More External Sources That Could Be Unsafe
- How to Create a Drop Down List Hyperlink to Another Sheet in Excel
- How to Link Picture to Cell Value in Excel (4 Quick Methods)
- Why Do My Excel Links Keep Breaking? (3 Reasons with Solutions)
- [Fix]: Excel Automatic Update of Links Has Been Disabled
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.
- 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.
- After clicking OK, we will get the following result.
- 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.
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
- How to Hyperlink to Cell in Excel (2 Simple Methods)
- How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)
- Excel Hyperlink to Another Sheet Based on Cell Value
- How to Use CELL Function in Excel (5 Easy Examples)
- [Fixed!] Break Links Not Working in Excel (7 Solutions)
- How to Extract Hyperlink from URL in Excel (3 Methods)