View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.