Excel: How to add a hyperlink to another sheet

How to add a hyperlink one Sheet to another sheet In Excel Insert a hyperlink in Excel If you need to add a hyperlink in Excel 2016 or ...

How to add a hyperlink one Sheet to another sheet In Excel

Insert a hyperlink in Excel
If you need to add a hyperlink in Excel 2016 or 2013, you can choose one of the following hyperlink types: a link to an existing or new file, to a web page or e-mail address. Since the subject of this article is creating a hyperlink to another worksheet in the same workbook, below you'll find out three ways to do that.

1st Formula

• Add a hyperlink from the context menu

The first method of creating a hyperlink within one workbook is to use the Hyperlink command.

1. Select a cell where you want to insert a hyperlink.
2. Right-click on the cell and choose the Hyperlink option from the context menu.






3. Choose Place in This Document in the Link to section if your task is to link the cell to a specific location in the same workbook.
4. Select the worksheet that you want to link to in the Or select a place in this document field.
5. Enter the cell address in the Type the cell reference box if you want to link to a certain cell of another worksheet.
6. Enter a value or name into the Text to display box to represent the hyperlink in the cell.



7. Click OK.

The cell content becomes underlined and highlighted in blue. It means that the cell contains the hyperlink is working so good. To check if the link works, just hover the pointer over the underlined text and click on it to go to the specified location.

2nd formula

Excel HYPERLINK function

Excel has a function named HYPERLINK that you can also use for creating links between spreadsheets in the sheet but its look so difficult to use this. If you are not good at entering Excel formulas immediately in the Formula bar, do the following:

1. Select the cell to which you want to add a hyperlink.
2. Go to Function Library on the FORMULAS tab.
3. Open the Lookup & Reference drop-down list and choose HYPERLINK.

Now you can see the function name in the Formula bar. Just enter the following two HYPERLINK function arguments in the dialog window: link_location and friendly_name.

In our case link_location refers to a specific cell in another Excel worksheet and friendly_name is the jump text to display in the cell.

Fill in the Link_location text box.
Add the number sign (#) before the specified location.

My recommendation try with 1st formula. this is the easy way to link one sheet to another sheet if you want sheet and single column try with 2nd formula.





Tags: