GoTo Sheet reference

  • Thread starter Thread starter mp
  • Start date Start date
M

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
 
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
Click to expand...

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.
 
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
 
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
 
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
Click to expand...
Click to expand...

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 said:
[]
do you have a tricky way to then return to the previous location? []
Click to expand...

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.
Click to expand...

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
 
CellShocked said:
[]
do you have a tricky way to then return to the previous location? []
Click to expand...

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.
Click to expand...

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
Click to expand...

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

john
 
john said:
CellShocked said:
[]

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.
Click to expand...

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
Click to expand...

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

john
Click to expand...

great to know!
Thanks
mark
 
Back
Top