Hyperlink to Another Sheet or Workbook – Excel & Google Sheets

This tutorial demonstrates how to hyperlink to another sheet or workbook in Excel and Google Sheets.

 

 

Link to Another Sheet

In Excel, you can create a hyperlink to a cell in another sheet. Say that you have value 25 in cell A1 of Sheet1 and want to create a hyperlink to this cell in Sheet2.

 

 

In order to do this, follow the next steps.

1. (1) Go to another sheet (Sheet2), (2) right-click a cell where you want to insert a hyperlink (A1), and (3) click Link.

 

 

2. In the Insert Hyperlink window, (1) select Place in This Document, (2) choose a sheet to which you want to link (Sheet1), (3) enter a cell that you want to link to (A1), (4) enter a text to display in a linked cell (Sheet1 – A1), and (5) click OK.

 

 

As a result, the hyperlink is inserted in cell A1 of Sheet2. By default, the text of the hyperlink is underlined and colored in blue. If you position a mouse cursor over the hyperlink, you will see the file destination and name, as well as a cell that it’s leading to.

 

 

And when you click on the hyperlink, you’ll be redirected to the linked cell.

 

 

The HYPERLINK Function

Another way to insert a hyperlink to another sheet is to use the HYPERLINK Function. To do this, enter the following formula in cell A1 of Sheet2:

=HYPERLINK(Sheet1!A1,"Sheet1 - A1")

 

 

The first argument of the function is the cell to which you want to navigate the link, and the second argument is the text that is displayed in the link. The result is the same as using the previous method.

Hyperlink to Another Workbook

Similar to linking to another sheet, you can also insert a hyperlink to another workbook. Say that in File 1.xlsx you have a value of 25 in cell A1, and want to link it to File 2.xlsx.

 

 

To do this, follow the next steps.

1. In File 2.xlsx, (1) right-click a cell where you want to insert a hyperlink (A1), and (2) click Link.

 

 

2. In the Insert Hyperlink window, (1) select Existing File or Web Page, (2) choose Current Folder, or (3) select a folder with a source file, and (4) select a file (File 1.xlsx). (5) Enter a text to display in the linked cell (File 1), and (6) click OK.

 

 

As a result, the hyperlink to File 1.xlsx is inserted into cell A1 of File 2.xlsx. If you position a mouse cursor over this cell, you will see the linked file destination and name.

 

 

If you click on the link, you will be redirected to cell A1 of the source file. If the source file is not opened, it will be opened once you click the hyperlink.

 

 

Link to Another Sheet in Google Sheets

To create a hyperlink to another sheet in Google Sheets, follow the next steps.

1. (1) Go to another sheet (Sheet2), (2) right-click a cell where you want to insert a hyperlink (A1), and (3) click Insert link.

 

 

2. Select a sheet that you want to link to (Sheet1).

 

 

As a result, the hyperlink is inserted in cell A1 of Sheet2. By default, the text of the hyperlink is underlined and colored in blue. If you click on a cell with the link, you will see the linked sheet.

 

 

And when you click on the hyperlink, you’ll be redirected to the linked sheet.

Link to Another Workbook in Google Sheets

Say that you have Google Sheets file File 1 with value 25 in cell A1, and want to link this cell to File 2. To achieve this, follow the next steps.

1. (1) Right-click the URL address of the source file (File 1), and (2) click Copy.

 

 

2. Now go to another file (File 2), and (1) right-click a cell where you want to insert a hyperlink (A1), and (2) click Insert link.

 

 

3. (1) Paste the copied link, (2) enter a text to display, and (3) click Apply.

 

 

As a result, the hyperlink is inserted in cell A1. If you click on this cell, you can navigate to the linked file (File 1).

 

 

Note: You can also use the HYPERLINK function in Google Sheets, same as in Excel. The only difference is that for Google Sheets, you have to enter the URL.