How to create Hyperlink to link spreadsheets in Excel

By creating Hyperlink in Excel spreadsheets, we can access any web page or manage spreadsheets in different sheets in the same data file. This makes it easier for users to move between spreadsheets, especially active files with multiple sheets, saving time and manipulation while working on Excel.

There are many different tricks for using Excel Hyperlink. And how to create Hyperlink in Excel between spreadsheets is different from creating Hyperlink in Excel with normal data. The following article Network administrators will guide you how to create Hyperlink to move to another spreadsheet in the same Excel file, and create Hyperlink to link to a completely new data file.

1. Create Hyperlink to link the workbook and Excel file:

How to create this Hyperlink will help you to link the spreadsheets located in the data sheets in the same Excel file together.

For example, with the spreadsheet below, an Excel file consists of 3 different working sheets. The first worksheet is List A1, and we will proceed to create Hyperlink to link with the remaining spreadsheets including List A2 and A3 List.

How to create Hyperlink to link spreadsheets in Excel Picture 1

Step 1:

Select the cell containing the data to which you want to link to another spreadsheet. Then, right-click and select Hyperlink . in the drop-down list.

How to create Hyperlink to link spreadsheets in Excel Picture 2

Step 2:

In the Insert hyperlink dialog interface, we select the Place in This Document item in the list to the left of the interface. Then look to the right of the Cell Referenc e entry, check the worksheet that we want to create the link and click OK .

How to create Hyperlink to link spreadsheets in Excel Picture 3

The spreadsheet results will look like the image below. When we click on the created Hyperlink, you will be immediately transferred to the linked worksheet.

How to create Hyperlink to link spreadsheets in Excel Picture 4

2. Create Hyperlink linked to another Excel file:

This way will help you quickly open another Excel file saved in your computer.

Step 1:

Also in the spreadsheet, select the data box you want to create a link to another Excel worksheet, then right-click and select Hyperlink . in the list.

How to create Hyperlink to link spreadsheets in Excel Picture 5

Step 2:

Also appears the Insert hyperlink dialog interface. Here, click on Existing File and Web page on the left side of the interface.

To the right, we find the folder containing the Excel file we want to add to the link , click and then click OK .

How to create Hyperlink to link spreadsheets in Excel Picture 6

When you return to the spreadsheet you will also see the Hyperlink link created. If you click on it, the Excel file will be opened.

How to create Hyperlink to link spreadsheets in Excel Picture 7

So with creating Hyperlink on Excel, we can create links with Excel spreadsheets in the same file or with a separate file. This will help you manage and open the data sheet faster, saving you time when working.

I wish you all success!