Home > Microsoft Office > Excel > Hyperlinks - Excel

Hyperlinks - Excel
You can create an internal hyperlink that takes you to another location within the same workbook when you click on it. For example, if your workbook contains an Overview worksheet, which refers to more detailed data in other worksheets within the same workbook, you might want to allow users to quickly jump to that data. This article shows Excel 2016, but this process also works in Excel 2013 & 2010.

Step 1:Launch Excel and open the workbook to which you want to add an internal hyperlink.Step 2:Select the cell you want to make your hyperlink.
Step 3:Click the Insert tab, then choose Hyperlink, or press [Ctrl] + [K] to open the Insert Hyperlink dialog box.
Step 4:Click the Place In This Document icon on the left of the Insert Hyperlink window.
Step 5:Specify the text you want the linked cell to display in the Text to display text box.
Step 6:If you would like the hyperlink to refer to a point on the same worksheet, enter the cell number in the "Type the cell reference" box. If you would like the hyperlink to refer to a different worksheet within the same workbook, choose the name of the worksheet under "Or select a place in this document."
Step 7:Click OK to create the hyperlink.
Now when a user clicks on the cell that contains the specified text, the active cell jumps to your specified destination.

From: New Horizons

Related Articles