# Link to certain cells (page views) within Calc? [closed]

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.

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?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-07-21 19:18:18.572793

Sort by » oldest newest most voted

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 ...

more

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!

( 2015-03-10 06:35:24 +0200 )edit

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.

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!

more