See all How-To Articles

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.

 

hyperlink another sheet 3

 

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.

 

hyperlink another sheet initial data

 

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.

 

hyperlink another sheet 1

 

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.

 

hyperlink another sheet 2

 

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.

 

hyperlink another sheet 3

 

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

 

hyperlink another sheet 4

 

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")

 

hyperlink another sheet 5

 

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.

 

hyperlink another workbook

 

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.

 

hyperlink another workbook 2

 

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.

 

hyperlink another workbook 3

 

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.

 

hyperlink another workbook 4

 

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.

 

hyperlink another workbook 5

 

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.

 

google sheets hyperlink another sheet 6

 

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

 

google sheets hyperlink another sheet 7

 

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.

 

google sheets hyperlink another sheet 8

 

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.

 

google sheets hyperlink another sheet 1

 

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.

 

google sheets hyperlink another sheet 2

 

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

 

google sheets hyperlink another sheet 4

 

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

 

google sheets hyperlink another sheet 5

 

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.