How do I make a hyperlink cell-specific between two XL sheets?

[Brian RRR]

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.

 

[Pete_UK]

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

 

[David Biddulph]

The function HYPERLINK (along with every other Excel function but one) is
covered in Excel help, & it gives examples there.

 

[Gord Dibben]

Insert>Hyperlink>Place in this document>Select a sheet and type in a cell
address where it says "Type the cell reference"


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 02:27:00 -0700, Brian RRR <Brian