N
Nora
Can I use a hyperlink to point to another location in the same book but on a
different page?
different page?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=HYPERLINK("#'some other sheet'!A1:A10")
This will jump to a tab called:
some other sheet
This will jump to a tab called:
some other sheet
E
Eduardo
Hi Nora,
yes you can , right click on the mouse, last option Hyperlink, then 2nd
option at your left said Place in this Document and enter the cell reference
If this helps please click yes, thanks
yes you can , right click on the mouse, last option Hyperlink, then 2nd
option at your left said Place in this Document and enter the cell reference
If this helps please click yes, thanks
N
Nora
Thank you both for your help.. I knew it can be done, I was just going blank..
E
Eduardo
your welcome
Nora said:Thank you both for your help.. I knew it can be done, I was just going blank..
D
Dave Peterson
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)
These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
These formulas will adjust if you change the sheet name or insert/delete
rows/columns on the linked sheet.