jump between sheets in LO calc

I am creating a LO document with several sheets. I want to be able to click in a cell and jump to another sheet.
I am not referring to clicking on the sheet names at the bottom, but the equivalent action when clicking in a cell on the sheet.

  • Choose menu View - Navigator (the same that press F5).
  • Unfold Sheets list item.
  • Drag each sheet name to desired cell.

image description

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

Menu Insert → Hyperlink… (Ctrl+K), in the left bar choose Document and as Target in Document Target enter something like Sheet2.B3 where you want to jump to; leave Document Path empty. You may provide a display text in Further Settings Text.

OK, this approach didn’t quite work, but I stumbled on one that does.

  1. Select cell to contain Jump Command
  2. Click on Hyperlink
  3. Click on Document
  4. Click on circle icon on right end of target edit field
  5. Click on Sheet arrow to open list of sheet names
  6. Click on Sheet name

this approach didn’t quite work

What exactly didn’t work?


The part "enter something like Sheet2.B3 where you want to jump to;” When I did that, nothing happened. Then I noticed the “circle” symbol at the right end and clicked on it. From there, I could select the sheet name.

LeroyG’s method works fine also.