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.

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.

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

"Brian RRR" <Brian wrote in message
...
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.

InsertHyperlinkPlace in this documentSelect 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
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.