How do I make a hyperlink cell-specific between two XL sheets?
Suppose you want to jump from A1 of sheet1 to B10 of sheet2 - put this
formula in A1 of sheet1:
=HYPERLINK("#sheet2!B10","jump")
The word "jump" will appear in the cell, and when you click on this
your cursor will jump to B10 of sheet2. Just adjust the sheet name and
cell reference to suit your situation.
Hope this helps.
Pete
On Apr 29, 10:27*am, Brian RRR <Brian
wrote:
When creating a hyperlink between two separate XL sheets, how do I make it
cell-specific?
Currently all I can do is make the hyperlink point to the sheet overall, not
to the specific cell.
I am using Excel 2003.
|