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.
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.
We have opened a worksheet called “Sheet2” in the same workbook and created an empty table there to insert the hyperlinks for the marks.
- 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.
- The symbol (#) is important. It denotes that the worksheet is from the same workbook.
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”.
- 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.
- The two workbooks must be in the same folder. Otherwise, you have to enter the full location of the workbook.
Read More: How to Hyperlink to Cell in Excel
If you don’t want to use the formula, you can add hyperlinks using the context menu of Excel.
Firstly, we will use the context menu for hyperlinking to another sheets from the same workbook.
- 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
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.
- 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.
- You can’t link to a specific cell in a different workbook in this way. You can just link to the workbook.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
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.
- How to Hyperlink to Cell in Same Sheet in Excel
- How to Combine Text and Hyperlink in Excel Cell
- How to Create a Drop Down List Hyperlink to Another Sheet in Excel
- How to Edit Hyperlink in Excel
- How to Create Dynamic Hyperlink in Excel
- How to Copy Hyperlink in Excel
- How to Convert Text to Hyperlink in Excel
- How to Create Button to Link to Another Sheet in Excel