I have a Google spreadsheet with many tabs. I would like to put a link in a cell on one tab that when clicked takes me to another cell on another tab.
Is this possible?
I've discovered this hack, perhaps it helps:
=HYPERLINK("paste here the URL copied at step 2", "enter link text here")
As of 13 February 2017, support for anchor links will be introduced:
Because it can be difficult to navigate large and complex spreadsheets, we’re introducing the ability to link to specific cell ranges in Google Sheets on the web. With this new functionality, you can create a “table of contents” for your spreadsheet, direct others to specific content within your spreadsheet, and retain links to cells when you import spreadsheets from other applications. To link to cells in your spreadsheet, simply go to "Insert link" > "Select a range of cells to link" and type or highlight the desired range. For more details, visit the Help Center.
Gradual rollout (potentially longer than 3 days for feature visibility)
Blog post reference: Anchor Links