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 pressF5). - Unfold Sheets list item.
- Drag each sheet name to desired cell.
Tested with LibreOffice 6.4.7.2 (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 (
) 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.
1 Like
OK, this approach didnât quite work, but I stumbled on one that does.
- Select cell to contain Jump Command
- Click on Hyperlink
- Click on Document
- Click on circle icon on right end of target edit field
- Click on Sheet arrow to open list of sheet names
- Click on Sheet name
this approach didnât quite work
What exactly didnât work?
@erAck
Your method works correctly.
- Creation of a Hyperlink
- Click on Document
- Into target : âname of the sheetâ.âcellâ
example : Fusion.b1
Fusion is a sheet and b1 is a cell of Fusion. - Text : the text you would like.
- Form : you can choose for a button.
If you donât pass a cell into target, you go to the sheet at the previous position, if you pass a cell then, you go to the sheet at the specific location.
The case seems unimportant.
Do not forget to click on âapplyâ.
erAck:
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.