On Sat, 19 Feb 2011 19:22:53 -0600, "mp" wrote:

Thanks Ken,
Double click doesn't work for me...(im on excel 2002)
ctl [ does work great, thanks a lot...I never knew that one.
do you have a tricky way to then return to the previous location?
ctl tab works in autocad to shift from one tab to another, but not in excel
on my machine

ha! I just accidentally discovered Alt E G Enter works to toggle back and
forth between
the last two navigated cells

very nice

thanks
mark

"Ken" wrote in message
...
Mark
A double click should do it. Also, control [ will take you to the
cell on the other sheet as well.
I hope this helps.
Ken


On Feb 18, 1:25 pm, "mp" wrote:
If I have a sheet/cell reference in, say somewhere on Sheet1 (or
whereever),
eg ='Sheet2'!A2
How can I make a right click menu item that would take me to Sheet2 A2?
I would have thought that might be a default menu item but I don't see it.

Thanks
Mark


You can also "name" a cell and place a hyperlink to it OR simply go up
to the name box, and type in that name, and it will take you to that
named cell (OR range of cells) regardless of which worksheet it is on/in.

Named ranges are cool.