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:
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
