N
Nora
Can I use a hyperlink to point to another location in the same book but on a
different page?
different page?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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
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
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..
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..
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.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.