Moving Between Worksheets

W

wormdazzler

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?
 
R

Ragdyer

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>
 
W

wormdazzler

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
 
R

RagDyeR

Hit <Enter>
--

HTH,

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

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
 
Top