Ask Your Question

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

asked 2015-03-09 11:03:55 +0200

Wildcard gravatar image

updated 2020-07-27 15:55:47 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive 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

2 Answers

Sort by » oldest newest most voted

answered 2015-03-09 11:52:28 +0200

karolus gravatar image

updated 2015-03-09 11:56:42 +0200

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

edit flag offensive delete link 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!

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

answered 2015-03-09 12:15:58 +0200

Lupp gravatar image

updated 2015-03-09 12:22:06 +0200

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!

edit flag offensive delete link more


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

Lupp gravatar imageLupp ( 2015-03-09 12:17:21 +0200 )edit

Question Tools

1 follower


Asked: 2015-03-09 11:03:55 +0200

Seen: 5,067 times

Last updated: Mar 09 '15