Create a Hyperlink to Another Worksheet or Excel Sheet

Create a Hyperlink to Another Worksheet or Excel Sheet

Tech-recipes.com/

Creating hyperlinks within a Microsoft Excel sheet helps you to navigate quickly to another worksheet or to another Excel sheet. By creating hyperlinks on the main page, you can keep a list of other worksheets and easily navigate through it. This definitely helps save time if you have several worksheets under an Excel sheet.

Creating a Hyperlink to Another Worksheet within the Same Excel Sheet

In the example below, I have created an Excel sheet which contains four different worksheets. The main worksheet is named Index. This is where we are going to create a hyperlink to other worksheets, which are named Finance, Account and HR.

Let us create a hyperlink to another worksheet from Index, the main worksheet.

1. Select the cell that contains the text you wish to link to another worksheet.

2. Right-click on the same cell, and click on the Hyperlink.. option.

3. In the Insert hyperlink window, navigate to Place in This Document. From the call referenceoption, select the sheet’s name to which you want to link, and click OK.

Creating hyperlinks within an Excel sheet is especially useful when you have a large number of worksheets in one sheet, since having many sheets together can be difficult to manage. Hyperlinks within a sheet can help save time and effort.

--------------------------------------------------------------------------------------------------------------------------------------------------------------