Moving Between Worksheets
 

I have a series of interrelated worksheets in a single spreadsheet program.
How can I move between worksheets so that I always arrive at the same cell
reference on the worksheet that move to, as on the one I am moving from?

Moving Between Worksheets
 

Group them just before the move.

When you're ready to change sheets, hold <Ctrl and click on the tab of the
sheet you're going to work on next.
Release <Ctrl and click in that sheet tab again and you'll be in that new
sheet with the focus on the cell you were in on the first sheet.

You now have to "break" the grouping (ungroup) before you can work in the
new sheet.
Right click in the sheet tab and choose "Ungroup".

NOW, this sounds kind of complicated with a lot of superfluous motions, but
I use this procedure, and once you become accustomed to what you're doing,
it's really fast and simple, considering 3 of the 4 clicks is in exactly the
same place, the new sheet tab, and the fourth is in the pop-up menu, right
next to that sheet tab.

<Ctrl <Click - <Click - <Right Click - <Click

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"wormdazzler" wrote in message
...
I have a series of interrelated worksheets in a single spreadsheet
program.
How can I move between worksheets so that I always arrive at the same cell
reference on the worksheet that move to, as on the one I am moving from?

Moving Between Worksheets
 

Thanks, Ragdyer, obviously it works just as you describe and that's certainly
helpful.
However, if the position of the cursor on the starting worksheet is
"off-screen" on the worksheet that you are moving to, you can't see it until
you re-align the sheet. Can I pin the relative positions of the worksheets
as well??
Wormdazzler

"Ragdyer" wrote:

Group them just before the move.

When you're ready to change sheets, hold <Ctrl and click on the tab of the
sheet you're going to work on next.
Release <Ctrl and click in that sheet tab again and you'll be in that new
sheet with the focus on the cell you were in on the first sheet.

You now have to "break" the grouping (ungroup) before you can work in the
new sheet.
Right click in the sheet tab and choose "Ungroup".

NOW, this sounds kind of complicated with a lot of superfluous motions, but
I use this procedure, and once you become accustomed to what you're doing,
it's really fast and simple, considering 3 of the 4 clicks is in exactly the
same place, the new sheet tab, and the fourth is in the pop-up menu, right
next to that sheet tab.

<Ctrl <Click - <Click - <Right Click - <Click

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"wormdazzler" wrote in message
...
I have a series of interrelated worksheets in a single spreadsheet
program.
How can I move between worksheets so that I always arrive at the same cell
reference on the worksheet that move to, as on the one I am moving from?

Moving Between Worksheets
 

Hit <Enter
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"wormdazzler" wrote in message
...
Thanks, Ragdyer, obviously it works just as you describe and that's
certainly
helpful.
However, if the position of the cursor on the starting worksheet is
"off-screen" on the worksheet that you are moving to, you can't see it until
you re-align the sheet. Can I pin the relative positions of the worksheets
as well??
Wormdazzler

"Ragdyer" wrote:

Group them just before the move.

When you're ready to change sheets, hold <Ctrl and click on the tab of
the
sheet you're going to work on next.
Release <Ctrl and click in that sheet tab again and you'll be in that new
sheet with the focus on the cell you were in on the first sheet.

You now have to "break" the grouping (ungroup) before you can work in the
new sheet.
Right click in the sheet tab and choose "Ungroup".

NOW, this sounds kind of complicated with a lot of superfluous motions,
but
I use this procedure, and once you become accustomed to what you're doing,
it's really fast and simple, considering 3 of the 4 clicks is in exactly
the
same place, the new sheet tab, and the fourth is in the pop-up menu, right
next to that sheet tab.

<Ctrl <Click - <Click - <Right Click - <Click

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"wormdazzler" wrote in message
...
I have a series of interrelated worksheets in a single spreadsheet
program.
How can I move between worksheets so that I always arrive at the same
cell
reference on the worksheet that move to, as on the one I am moving from?