How to☝️ Link to Another Sheet or Spreadsheet in Google Sheets

To link to another sheet in Google Sheets, right-click on any empty cell, click “”Insert Link,” and select that sheet you want to hyperlink to from the list.

If you want to link to another Google spreadsheet, you need to use another method, so stick around to learn everything you need to know to build an ecosystem of intertwined sheets and documents.

How to Link to Another Sheet

First, let’s start off by showing the quickest way to link to another sheet.

  1. Right-click on the cell where you want to create a hyperlink.
  2. Choose “Insert link.

How to Link to Another Sheet

  1. Once the dialog box pops up, choose the sheet you want to hyperlink to (in our case, that’s sheet “Cities”).

How to Link to Another Sheet in Google Sheets

After that, Google Sheets will create a link pointing to the sheet you specified. The anchor text of the link will be pulled from the name of the corresponding sheet.

Here’s the example of it looks:

Link in Google Sheets

Alternatively, if you’re looking for more customization options, you can select “Sheets and named ranges” to select either a sheet, named range, or cell range to link to.

Sheets and named ranges

Links in Google Sheets

How to Link to Another Google Spreadsheet

If you’re looking for a way to link out to another Google spreadsheet, the method we showed above doesn’t cut it.

Here’s what you need to do instead:

  1. Copy the URL of the Google spreadsheet you want to link out to in your hyperlink.

How to Link to Another Google Spreadsheet

  1. Go back to the original Google spreadsheet and right-click on any empty cell where you want to insert the hyperlink.
  2. Click “Insert link.

Insert link

  1. Paste the URL you copied into the search field.
  2. In the Text field, write a description that will be used as the anchor text.
  3. Click “Apply” to close out.

The Apply tab in Google Sheets

Having followed the steps outlined above, you get a hyperlink going to another Google spreadsheet, helping you build a web of interconnected documents.

Hyperlink in Google Sheets

How to Link to Values in Another Sheet in a Formula

Finally, if you want to reference values in another sheet inside a Google Sheets function or formula, all you need to do is follow these steps:

  1. Type in your function or custom formula.

How to Link to Values in Another Sheet in a Formula

  1. Whenever you want to reference values in another sheet, switch over to another tab, and select the values you want to link to.

Reference values in Google Sheets

  1. Click Enter to execute the formula.

Google Sheets will automatically add a cell reference. However, if you want to do that manually, let’s break down how it works in Google Sheets to help you adjust accordingly with your data.

The cell reference used as a running example (Cities!E2) is made up of three parts:

  • Cities” defines the sheet you refer to within a given Google Sheets file.
  • !” acts as a separator.
  • E2” refers to the value you link out to. You can use both individual cells or cell ranges.

The Value

There you have it. You now have all the tools you need to leverage the power of hyperlinks in Google Sheets to connect values, sheets, and even separate files between each other.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X