Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Open Multiple Hyperlinks at Once in Excel?
Excel's sophisticated hyperlink tool enables you to link to websites, files, or even particular areas inside a spreadsheet. You can save time and effort by opening numerous URLs at once, especially when working with large datasets or long lists.
We can help you browse to any portion of your workbook or open a collection of online pages, files, or other resources. You will have a thorough understanding of how to quickly access many hyperlinks by the end of this session, enabling you to improve productivity and streamline your workflow. So let's get started and learn the tricks for opening several hyperlinks in Excel quickly!
Open Multiple Hyperlinks at Once
Here, we will first create a VBA module and then run it to complete the task. So let us see a simple process to learn how you can open multiple hyperlinks at once in Excel.
Step 1
Consider any Excel worksheet where you have multiple hyperlinks.
First, right-click on the sheet name and select View code to open the VBA application.
Right click > View Code.
Step 2
Then click on Insert, select Module, and copy the below code into the text box.
Insert > Module > Copy.
Code
Sub OpenHyperLinks()
Dim xHyperlink As Hyperlink
Dim WorkRng As Range
On Error Resume Next
xTitleId = "Open Multiple Hyperlinks"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each xHyperlink In WorkRng.Hyperlinks
xHyperlink.Follow
Next
End Sub
Step 3
Then save the sheet as a macro-enabled template, click F5 to run the module, select the range of cells, and then click Ok to complete the task.
Save > F5 > Select Cells > Ok.
Then you can see that all the hyperlinks in the selected range will be opened.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can open multiple hyperlinks at once in Excel to highlight a particular set of data.
6K+ Views
