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.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
2 Easy Ways to Add 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.
Method 1: Using 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, then to a different workbook.
1.1 Add 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.
- 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.
1.2 Add 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”.
- 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: VBA to Add Hyperlink to Cell Value in Excel (4 Criteria)
- How to Find and Replace Hyperlinks in Excel (3 Quick Methods)
- Excel Hyperlink to Cell in Another Sheet with VLOOKUP (With Easy Steps)
- How to Activate Multiple Hyperlinks in Excel (4 Ways)
- [Fix]: Excel Automatic Update of Links Has Been Disabled
- How to Remove Hyperlink Permanently in Excel (4 Ways)
Method 2: Utilizing 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 Add Hyperlink to Different Worksheets in Same Workbook
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.
2.2 Add 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.
- 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.
Read More: Excel Hyperlink to Another Sheet Based on Cell Value
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 Create Dynamic Hyperlink in Excel (3 Methods)
- Excel Hyperlink with Shortcut Key (3 Uses)
- Combine Text And Hyperlink in Excel Cell (2 Methods)
- How to Edit Links in Excel (3 Methods)
- [Fix:] Hyperlink to Website Not Working in Excel
- How to Break Links in Excel (3 Quick Methods)
- [Fixed!] Hyperlinks in Excel Not Working After Saving (5 Solutions)