hYPERLINK
 

Can I use a hyperlink to point to another location in the same book but on a
different page?

hYPERLINK
 

=HYPERLINK("#'some other sheet'!A1:A10")

This will jump to a tab called:
some other sheet
--
Gary''s Student - gsnu200855


"Nora" wrote:

Can I use a hyperlink to point to another location in the same book but on a
different page?

hYPERLINK
 

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

"Nora" wrote:

Can I use a hyperlink to point to another location in the same book but on a
different page?

hYPERLINK
 

Thank you both for your help.. I knew it can be done, I was just going blank..

"Nora" wrote:

Can I use a hyperlink to point to another location in the same book but on a
different page?

hYPERLINK
 

your welcome

"Nora" wrote:

Thank you both for your help.. I knew it can be done, I was just going blank..

"Nora" wrote:

Can I use a hyperlink to point to another location in the same book but on a
different page?

hYPERLINK
 

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!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.

Nora wrote:

Can I use a hyperlink to point to another location in the same book but on a
different page?

--

Dave Peterson