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

=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?

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?

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?

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?

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