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

mp formulated on Friday :
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

Try this...

=HYPERLINK("[Book1]Sheet2!A2",Sheet2!A2)

... where 'Book1' is the name of your file.
The value of the target location is what displays in the cell. Just
click the cell to go there.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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

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

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.

"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote
in message ...
On Sat, 19 Feb 2011 19:22:53 -0600, "mp" wrote:

[]

do you have a tricky way to then return to the previous location?
[]


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.

true and i use them when a range has a specific meaning to me (or the
spreadsheet)
my question above was more one of how to return to previous location -
just a simple navigation process,

in that case naming a cell before leaving it just so
i could use the name to return there would be overkill for a one time
temporary navigation

alt e g <enter worked great for that (even though it's twice as many
keystrokes as I would
have thought there might be)
thanks
mark

"john" wrote in message
...
On Sat, 26 Feb 2011 11:55:10 -0600, "mp" wrote:


"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote
in message ...
On Sat, 19 Feb 2011 19:22:53 -0600, "mp" wrote:

[]

do you have a tricky way to then return to the previous location?
[]


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.

true and i use them when a range has a specific meaning to me (or the
spreadsheet)
my question above was more one of how to return to previous location -
just a simple navigation process,

in that case naming a cell before leaving it just so
i could use the name to return there would be overkill for a one time
temporary navigation

alt e g <enter worked great for that (even though it's twice as many
keystrokes as I would
have thought there might be)
thanks
mark


F5 <enter should do the same, and halves the keystrokes.

john

great to know!
Thanks
mark