links?

  • Thread starter Thread starter anne
  • Start date Start date
A

anne

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?
 
--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","")
 
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.
 
Back
Top