How to Add Hyperlink to Another Sheet in Excel (2 Easy Ways)

Perhaps one of Excel’s most important and complex activities while working on big projects is adding hyperlinks. We have to add hyperlinks. We have to add one or more hyperlinks to worksheets of the same workbook or different workbooks in a worksheet in Excel. Today I will show how to add a hyperlink to another sheet in Excel.

This article will demonstrate how to add hyperlinks to another sheet by using the HYPERLINK function and the Context Menu. Here we’ve got a worksheet called “Sheet1” with the names of some students and their marks in the examination of a school called Sunflower Kindergarten. Our objective today is to add hyperlinks to this sheet in another worksheet of the same workbook or a different workbook.

1. Inserting HYPERLINK Function to Add Hyperlink to Another Sheet in Excel

We can add hyperlinks through the HYPERLINK function in Excel. This is the simplest way, in fact. First, we shall add hyperlinks to a worksheet of the same workbook, and then to a different workbook.

1.1 Adding Hyperlink to Different Worksheets in Same Workbook

We have opened a worksheet called “Sheet2” in the same workbook and created an empty table there to insert the hyperlinks for the marks.

Steps:

• Firstly, to add a hyperlink in the sheet, select a cell and enter the HYPERLINK function.

The Syntax of the HYPERLINK Function is:

• Then, to create a link to cell C5 of Sheet1, the link_location will be “#Sheet1!C4”.
• After that, friendly_name is any convenient name that you want to show as the link. For this example, I name it “Marks”.
• So, the HYPERLINK formula for this example will be:

• Besides, press Enter.

• Therefore, you will see the result for the grade.
• Additionally, use the Fill Handle tool and drag it down from the C5 cell to the C21 cell.

• Finally, you will get all the hyperlinked marks in the below image.

Read More: Excel Hyperlink to Another Sheet Based on Cell Value

1.2 Adding Hyperlink to Different Worksheets in Different Workbooks

To create a hyperlink to a worksheet of a different workbook, enter the name of the workbook before the worksheet name, enclosed by a square bracket [ ], inside the HYPERLINK function. Here we’ve created a new workbook called “Book2”. And the previous workbook was “Book1”.

Steps:

• Firstly, to create a hyperlink to cell C5 of Sheet1 of Book1 in the Sheet1 of Book2, the HYPERLINK formula will be:

• Finally, you will get the same results for the different worksheets.

Read More: How to Hyperlink to Cell in Excel

2. Using Context Menu to Add Hyperlink to Another Sheet in Excel

If you don’t want to use the formula, you can add hyperlinks using the context menu of Excel.

2.1 Adding Hyperlink to Different Worksheets in Same Workbook

Firstly, we will use the context menu for hyperlinking to another sheets from the same workbook.

Steps:

• Firstly, right-click on the cell where you want to enter the hyperlink. From the options available in the below image, select the Link.

• After clicking on the Link, you will get a dialogue box called Insert Hyperlink.
• To add a hyperlink to a worksheet of the same workbook, Select Place in this Document from the left panel.
• So, in the Text to Display box, enter the name of the link to show. For this example, I enter it as Marks.
• Then, in the Type the Cell reference box, enter the cell reference of the cell that you want to link. For this example, it is C5.
• After that, in the select a place in this document box, select the worksheet name to which you want to link. For this example, it is Sheet1.

• Then, click OK. And you will see a hyperlink has been created on your selected cell.

Read More: Excel Hyperlink with Shortcut Key

2.2 Adding Hyperlink to Different Worksheets in Different Workbooks

You can also use this method to create a hyperlink to a worksheet in a different workbook. Here, we have opened a new workbook called “Book2”. Now we want to add a hyperlink from Sheet1 of Book2 to Sheet1 of Book1.

Steps:

• So, follow the same procedure as discussed above to open the Insert Hyperlink dialogue box.
• Therefore, in the Insert Hyperlink dialogue box, from the left panel, click on Existing File or Web Page.
• Then,  browse the workbook to which you want to link. For this example, I want to link to Book1.

• Then, click OK. You will find a hyperlink created on your selected cell connecting you to the desired workbook.

Read More: Excel Hyperlink to Cell in Another Sheet with VLOOKUP

Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

Conclusion

Using these methods, you can add a hyperlink from a worksheet to another worksheet of the same workbook or a different workbook in Excel. Do you know any other method? Or do you have any questions? Feel free to ask us.

Excel Hyperlink to Another Sheet: Knowledge Hub

• Excel Hyperlink to Another Sheet Based on Cell Value
• Create a Drop Down List Hyperlink to Another Sheet
• Create Button to Link to Another Sheet
• Excel Hyperlink to Cell in Another Sheet with VLOOKUP

<< Go Back To Hyperlink in Excel | Linking in Excel | Learn Excel