I want to make a link between two spreadsheets, like if I click on a code in a cell, it opens the spreadsheet which the code refers/links to.

2 Answers 2


You want to enter a link in a Google spreadsheet.

The syntax of the command is: =hyperlink("url";"Phrase")

The key is that the Google spreadsheet you want to open has a URL.


I use the Google Sheet Add-on called Sheetgo. It's easy to use and after installing, gives you the ability to link sheet in many way, even if you need to connect multiple sheets.

  • 2
    Can you link to the add on?
    – ale
    May 22, 2017 at 19:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.