Link to other sheet/tab within spreadsheet

User Support Calc
1

I would like to link text in a cell to another sheet/tab in my spreadsheet. For example, if I have 2 sheets ( ‘summary’ and ‘yearly budget’ ) how can I create a link on the summary tab that says Current Budget that links to my yearly budget sheet/tab?

I see no way to reference the actual sheet. I can reference a cell in the sheet ( =‘yearly budget’.A1 ) and get the value but that’s not what I want. I want a hyperlink, but when I insert hyperlink it only gives me a URL option.

For clarity, the sheets/tabs are in the same spreadsheet.

Any help is appreciated!

2

Hi @jitterbug and sorry for the delay,

Normally, on desktop (Collabora Office), you would do =HYPERLINK($Sheet2.A1,my link) but unfortunately links (not references) between sheets from the same document or different documents are not supported yet.

3

@pedro.silva Thanks for letting me know.