How to Link to Another Tab in Google Sheets (With Examples)


Often you may want to link from one tab in a Google Sheets spreadsheet to another tab in the same spreadsheet.

Fortunately this is easy to do using the HYPERLINK() function and the following example shows how to do so.

Example: Link to Another Tab in Google Sheets

Suppose we have the following spreadsheet that has four tabs containing various information about basketball teams:

To create a link to the Points tab, first click on the Points tab and then copy the URL at the top of your browser.

You’ll notice that the URL of the Points tab will be different than the Team tab. For example, the URL of the Team tab ends with:

#gid=0

Conversely, the URL of the Points tab ends with:

#gid=788433911

We can then type in the following formula in cell B2 to create a link to the Points tab:

=HYPERLINK("https://docs.google.com/spreadsheets/d/1jTA/edit#gid=788433911", "Points")

Once we do so, a hyperlink will appear in the spreadsheet:

link to another tab in Google Sheets

When we click this hyperlink, it will automatically take us to the Points tab:

Note that we can use this same process to create a link to the Assists and Rebounds tabs as well.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Query From Another Sheet
Google Sheets: How to Query From Multiple Sheets
Google Sheets: How to Sum Across Multiple Sheets

Leave a Reply

Your email address will not be published.