Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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.


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.

Easy Ways to Add Hyperlink to Another Sheet in Excel


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.

Steps:

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

The Syntax of the HYPERLINK Function is:

=HYPERLINK(link_location,friendly_name)
  • 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:
=HYPERLINK("#Sheet1!C5","Marks")
  • Besides, press Enter.

Add Hyperlink to Different Worksheets in Same Workbook in Excel

  • 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.

Notes
  • 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”.

Steps:

  • Firstly, to create a hyperlink to cell C5 of Sheet1 of Book1 in the Sheet1 of Book2, the HYPERLINK formula will be:
=HYPERLINK("[Book1]Sheet1!C5","Marks")
  • Finally, you will get the same results for the different worksheets.

Add Hyperlink to Different Worksheets in Different Workbooks in Excel

Notes
  • The two workbooks must be in the same folder. Otherwise, you have to enter the full location of the workbook.

Similar Readings:


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.

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.

Add Hyperlink to Different Worksheets in Same Workbook in Excel

  • 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.

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.

Add Hyperlink to Different Worksheets in Different Workbooks in Excel

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

Notes
  • You can’t link to a specific cell in a different workbook in this way. You can just link to the workbook.

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.


Further Readings

 

Rifat Hassan

Rifat Hassan

Hello! Welcome to my profile. Here I will be posting articles related to Microsoft Excel. I am a passionate Electrical Engineer holding a Bachelor’s degree in Electrical and Electronic Engineering from the Bangladesh University of Engineering and Technology. Besides academic studies, I always love to keep pace with the revolution in technology that the world is rushing towards day by day. I am diligent, career-oriented, and ready to cherish knowledge throughout my life.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo