I need to create a relative link (eg #gid=0&range=B10) to the doc/sheet itself.

What are some solutions?

2 Answers 2


Use the HYPERLINK function. For example:


You can refer to named ranges or cells, in addition to external content. Use Insert -> Link menu to access the link function.

  • are there other solutions that are more "scripting"?
    – Pacerier
    Dec 3, 2018 at 17:08
  • What do you mean by scripting?
    – Oren
    Dec 4, 2018 at 13:59

I use the formula 'SheetName'!E73

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.