If you are searching for some of the ways to activate multiple hyperlinks in Excel, then you are in the right place. So, let’s get started with our main article.
Download Workbook
4 Ways to Activate Multiple Hyperlinks in Excel
In the following dataset, we can see there is a list of some of the famous e-commerce sites and their corresponding website addresses. But the website links are not activated so you cannot go to those sites by clicking on these links. To solve this problem, we have discussed 4 ways to activate these multiple hyperlinks quickly.
We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.
Method-1: Using HYPERLINK Function
Here, we will turn the following inactivated website links for the e-commerce sites into active links by using the HYPERLINK function. To gather the activated links we have added the column Linked Address.
Steps:
➤ Select the range of the Linked Address column.
➤ Type the following formula in the first cell D4 of the selected range.
=HYPERLINK(C4)
HYPERLINK will activate the text URL in cell C4.
➤ Press CTRL+ENTER.
After that, you will get all of the hyperlinks activated in the Linked Address column, so you can go to the website of these e-commerce sites directly by just clicking on these links.
Read More: How to Use CELL Function in Excel (5 Easy Examples)
Method-2: Activate Multiple Hyperlinks Using VBAÂ Selection Property
In this section, we will use a VBA code with the Selection property to activate a bunch of links in the Website Link column by only selecting them.
Step-01:
➤ Go to the Developer Tab >> Visual Basic Option.
Then, the Visual Basic Editor will open up.
➤ Go to the Insert Tab >> Module Option.
After that, a Module will be created.
Step-02:
➤ Write the following code
Sub activatinglinks()
Dim w_link As Variant
For Each w_link In Selection
ActiveSheet.Hyperlinks.Add Anchor:=w_link, Address:=w_link.Formula
Next w_link
End Sub
Here, we have declared w_link as a Variant and the FOR loop is used later for going through each cell w_link of our selection and then used the HYPERLINKS function for activating each of the text URLs of this range.
After saving the code, return to the main sheet.
➤ Select the range of the text URLs in the Website Link column, and then, go to the Developer Tab >> Macros Option.
After that, the Macro dialog box will open up.
➤ Select the macro activatinglinks and then click on the Run option.
Immediately after you will get the activated hyperlinks in the Website Link column, so you can go to their websites by only clicking on the links.
Read More: How to Get Hyperlink from an Excel Cell with VBA (3 Methods)
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)
- [Fixed!] ‘This workbook contains links to other data sources’ Error in Excel
Method-3: Using VBA InputBox Method to Activate Multiple Hyperlinks
In this section, we will use the InputBox method to have an input box after running the code and then selecting the range of multiple hyperlinks we will be able to activate them immediately.
Steps:
➤ Follow Step-01 of Method-2.
➤ Write the following code
Sub enablinglinks()
Dim w_link As Variant
Dim multiple_links As Range
Box = "Activation of Links"
Set multiple_links = Application.Selection
Set multiple_links = Application.InputBox("Select the Range of URL's", _
Box, multiple_links.Address, Type:=8)
For Each w_link In multiple_links
ActiveSheet.Hyperlinks.Add w_link, w_link.Value
Next w_link
End Sub
Here, we have declared w_link as Variant and multiple_links as Range. Then, we have defined the title of the input box as Activation of Links which is stored in the Box, and set multiple_links to the range in which we will be selected. Finally, the InputBox method is assigned to the multiple_links.
The FOR loop is applied later for going through each cell w_link of the selected range multiple_links and then used the HYPERLINKS function for activating each of the text URLs of this range.
➤ Press F5.
Then, you will get the input box where you have to select the range of the hyperlinks $C$4:$C$12 in the Select the Range of URL’s box and finally press OK.
Afterward, you will be able to activate multiple hyperlinks of the Website Link column in Excel.
Read More: Excel Hyperlink with Shortcut Key (3 Uses)
Method-4: Activating Hyperlinks by Declaring a Range
Here, we will define the range of the hyperlinks in a VBA code and then after running it we will get the activated hyperlinks at once.
Steps:
➤ Follow Step-01 of Method-2.
➤ Write the following code
Sub enablinglinks1()
Dim w_link As Variant
Dim multiple_links As Range
Set multiple_links = Range("C4:C12")
For Each w_link In multiple_links
ActiveSheet.Hyperlinks.Add w_link, w_link.Value
Next w_link
End Sub
Here, we have declared w_link as Variant and multiple_links as Range. Then, we have set multiple_links to the range C4:C12.
Later, we applied the FOR loop for going through each cell w_link of the defined range multiple_links and then used the HYPERLINKS function for activating each of the text URLs of this range.
➤ Press F5.
Finally, we will be able to convert the text URLs into the activated hyperlinks in the Website Link column.
Read More: How to Create a Hyperlink in Excel (5 Easy Ways)
Practice Section
For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.
Conclusion
In this article, we tried to cover the ways to activate multiple hyperlinks in Excel easily. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.
Related Articles
- How to Hyperlink to Cell in Excel (2 Simple Methods)
- How to Edit Links in Excel (3 Methods)
- [Fixed!] Break Links Not Working in Excel (7 Solutions)
- How to Create Dynamic Hyperlink in Excel (3 Methods)
- Hyperlink in Excel VBA: Properties and Applications
- How to Edit Hyperlink in Excel (5 Quick & Easy Ways)