Link to certain cells (page views) within Calc?

[Wildcard]

Hello, I remember I had done this successfully some years ago but I can’t remember how I set it up:

On a giant sheet which contained many charts, I set it up so that there was a sort of “table of contents” (manually set up) at the very top left, so when you opened that sheet you would see cells which you could click to view all the charts in that sheet.

For example, cell C5 might contain text reading “click here to view chart ABC.” When you click C5, your view would jump so that cell AA576 was in your top left corner, and you were looking at chart ABC. Then cell AB577 would have text saying “click here to go back to the table of contents” and you would click it and your page view would jump to A1 in the top left.

It was very handy for navigating large sheets and made the file much more user friendly than using vast amounts of scrolling or switching between vast numbers of sheets. I don’t remember what option I used to make this type of link. Can anyone help with this?

[karolus]

First - of all - you should give descriptive Names to your “Ranges of Interest” → insert → Names ...

after that – have a look on the features which are provided by Navigator (Shortcut F5 ) “out of the box”…

if you need - after all - some self-customized Links :
Use Calc-function HYPERLINK like =HYPERLINK("#Sheetname.A1";"click")
or ìn similar way →insert → Hyperlink ...

[Wildcard]

Perfect! Actually that’s even better than I had done it some years ago. Nice to see that it plays nice with named ranges, also. If you name a cell or a range “pig” (without the quotes), you can link to it with =hyperlink("#pig",“click here”). Good to know!

[Lupp]

For any target you want to be able to go to by a click you can insert a hyperlink of the ‘Document’ type leaving the ‘Path’ line empty (‘this document’ that meaning) and selecting the proper sheet or rangename from the navigator-like little window that will open. You may manually append a cell address or a cell range to it.

See attached document for examples.ask47391RangeHyperlinksInCalc001.ods

Editing: Don’t miss the post by @karolus . In specific the abbreviation for the target using the HYPERLINK function when inside the same document I was not aware of!

[Lupp]

@karolus - I was interrupted. Thus my post crossed yours.