Can I jump to a cell in another worksheet

[PCRONE]

I'm trying to figure out if functionality exists in MS Excel 2007 which will
allow me to JUMP from one cell to another cell in a different worksheet
simply by clicking on the first cell.
Kind of like a hyperlink, but I don't want to open anything, just jump from
one cell to another.
HELP !!

 

[Tyro]

Sure. If you want to go from cell A1 on sheet1 to cell B6 on sheet2, right
click cell A1, select hyperlink, in "link to:" select "Place in this
document", in the "Type in the cell reference" box put B6 and select the
sheet (sheet2) and put whatever text you want to display in the box "Text to
display". When you click on cell A1, sheet1 you will go to cell B6, sheet2.

Tyro

 

[Pete_UK]

As in my reply to your other post, you can use the HYPERLINK function. For
example, put this formula in A1 of Sheet1:

=HYPERLINK("#Sheet2!A10","jump")

The message "jump" will appear in the cell, and if you click on that cell
you will jump to A10 of Sheet2.

Hope this helps.

Pete