Shortcuts

  • Thread starter Thread starter UNK
  • Start date Start date
If you are within the workbook in question, you can use a hyperlink. Insert >
hyperlink > place in this document.
 
Not without VBA

But you could add a clickable hyperlink to go to another sheet.

CTRL + Pageup and Pagedown will cycle through sheets.


Gord Dibben MS Excel MVP
 
David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

You could also use this syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns.

So you'll want to choose the one that fits your requirements.
 
Back
Top