[Solved] Spreedsheets cell to cell click link same workbook
[Solved] Spreedsheets cell to cell click link same workbook
Ok here is what I am trying to do. I have many different spreedsheet on one work book and what I need is to make a quick link where for example ss1 has Gus on a5 and ss5 has Gus on a30. Ss1 is like a table of contents. How do I make it so that I click on ss1 Gus and it takes me to ss5 gus
Last edited by Hagar Delest on Mon Nov 20, 2017 11:32 pm, edited 2 times in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Open office 4.1.3 windows 10
Re: 2 spreed sheets cell to cell click link same work book
You can use the HYPERLINK() function. Here is an example from the help section
=HYPERLINK("#Sheet1.A1";"Go to top")
displays the text Go to top and jumps to cell Sheet1.A1 in this document.[/code]
=HYPERLINK("#Sheet1.A1";"Go to top")
displays the text Go to top and jumps to cell Sheet1.A1 in this document.[/code]
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: 2 spreed sheets cell to cell click link same work book
Re wrote what I was asking I tried but it didn't make a link
Open office 4.1.3 windows 10
Re: 2 spreed sheets cell to cell click link same work book
Click on the text in cell Sheet1.A3 and it will take you to Sheet2.A4
- Attachments
-
- Hyperlink.ods
- (8 KiB) Downloaded 127 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: 2 spreed sheets cell to cell click link same work book
Thank you that is exactly what I was looking for
Open office 4.1.3 windows 10