Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

links?

0 views
Skip to first unread message

anne

unread,
Jan 4, 2010, 11:14:01 PM1/4/10
to
How do I set up a cell so that when you click on it, it directs you to an
explanation of the data on another worksheet?

Jacob Skaria

unread,
Jan 4, 2010, 11:36:01 PM1/4/10
to
--Right click on the cell>Hyperlink>From the left "Link to" icon list select
''Place in this document'> Select the sheet name and enter the cell
reference..

--OR try the below formula to refer Sheet2 cell C3

=HYPERLINK("#Sheet2!C3","")

--
Jacob

Dave Peterson

unread,
Jan 5, 2010, 9:14:22 AM1/5/10
to
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--or delete Sheet3!!!

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

anne wrote:
>
> How do I set up a cell so that when you click on it, it directs you to an
> explanation of the data on another worksheet?

--

Dave Peterson

0 new messages