Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
How do I hyperlink to a cell on the same sheet? I would like to click on a cell and be taken to another page in the same sheet.
Mike,
I assume by "another page in the same sheet" you mean somewhere else in the same sheet, probably in an area not currently displayed.
I don't think you can.
Here's too semi work arounds
1. If this is two specific cells you frequently travel between, then you could link them via a 2nd sheet and use the shortcuts to travel to the cells in two "jumps".
Does not seem very useful except in a very limited sense.
2. Ctrl+G will open the Go To Row dialog -- if you know what the row # is, you can at least get that far.
I would vote for a Go To Cell feature, but probably would not use it very much because I don't keep the cell referencing in my head.
Craig
Hi,
I have a workaround that might help.
Please see the attached link/screenshot for more information.
https://cl.ly/d71b0a
Depending on your country you’ll need to exchange the semi-colon to a comma in the above formulas.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It took a while to grok what you were trying to do there Andrée.
I use Ctrl+G mostly on large sheets to get to the bottom quickly.
You solution might help with the ones were I want to go the last row of a section, not the header, so thanks for that.
Glad to hear that it's useful for you!
I think it will be beneficial for big projects, sheets with different phases or sections.
Even better if we could freeze rows, but yes, I see it.
