How to Activate Multiple Hyperlinks in Excel (4 Ways)

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.

how to activate multiple hyperlinks in Excel

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.

how to activate multiple hyperlinks in Excel

Steps:
➤ Select the range of the Linked Address column.

HYPERLINK function

➤ 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.

HYPERLINK function

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.

how to activate multiple hyperlinks in Excel

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.

how to activate multiple hyperlinks in Excel

Step-01:
➤ Go to the Developer Tab >> Visual Basic Option.

Selection property

Then, the Visual Basic Editor will open up.
➤ Go to the Insert Tab >> Module Option.

Selection property

After that, a Module will be created.

how to activate multiple hyperlinks in Excel

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.

Selection property

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.

Selection property

After that, the Macro dialog box will open up.
➤ Select the macro activatinglinks and then click on the Run option.

Selection property

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.

how to activate multiple hyperlinks in Excel

Read More: How to Get Hyperlink from an Excel Cell with VBA (3 Methods)


Similar Readings


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.

how to activate multiple hyperlinks in Excel

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.

InputBox method

➤ 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.

InputBox method

Afterward, you will be able to activate multiple hyperlinks of the Website Link column in Excel.

InputBox method

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.

how to activate multiple hyperlinks in Excel

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.

Declaring a range

➤ Press F5.
Finally, we will be able to convert the text URLs into the activated hyperlinks in the Website Link column.

Declaring a range

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.

Practice


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

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo