Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut for moving between Worksheets | Excel Discussion (Misc queries) | |||
Arrow keys scroll worksheets L R Up Dn instead of moving the curso | Excel Discussion (Misc queries) | |||
Moving dates between worksheets | Excel Discussion (Misc queries) | |||
Moving worksheets in a book | Excel Worksheet Functions | |||
Moving data between worksheets | Excel Worksheet Functions |