GoTo Sheet reference

[mp]

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

 

[GS]

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.

 

[Ken]

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

 

[mp]

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

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

 

[CellShocked]

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

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

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.

 

[mp]

[]

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]

[]

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

 

[mp]

[]

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