keyboard shortcuts to switch sheets?

[Sandra]

Anyone know if there's a keyboard shortcut to navigate to the next
sheet in Excel?

When I'm making changes, I tend to make a change, switch to the next
sheet, make the same change, switch to the next sheet, etc., etc.,
etc.
Excel is going to give me carpal tunnel syndrome in my mouse hand...
I'm wondering if there's a keyboard shortcut I can use instead.

Thanks!

Sandra

 

[Bernard Rey]

Sandra wrote :

Anyone know if there's a keyboard shortcut to navigate to the next
sheet in Excel?

"Control-Page up" or "Control-Page down" (the arrows just under the "F15"
Key) will do that.

When I'm making changes, I tend to make a change, switch to the next
sheet, make the same change, switch to the next sheet, etc., etc.,
etc.

May be you should try this: if you select the first sheet's tab, then,
holding the Caps key (or Command Key) select the last sheet you mean to
modify. You create a group (see the [Group] indication in the title bar).
Every modification you'll bring now will concern every sheet in the group.

When you're through, just click on one single sheet's tab and you're back...

Excel is going to give me carpal tunnel syndrome in my mouse hand...
I'm wondering if there's a keyboard shortcut I can use instead.

 

[Neill Massello]

Anyone know if there's a keyboard shortcut to navigate to the next
sheet in Excel?

When I'm making changes, I tend to make a change, switch to the next
sheet, make the same change, switch to the next sheet, etc., etc.,
etc.
Excel is going to give me carpal tunnel syndrome in my mouse hand...
I'm wondering if there's a keyboard shortcut I can use instead.

Pressing the Option key with the left or right arrow keys moves to the
next or previous sheet in a workbook. Control + Tab steps through open
workbooks.

 

[Sandra]

Thanks to you both these are wonderful tips.
I love keyboard shortcuts...

Not sure why I didn't think of the group function... I use it a lot to
format sheets in page setup, and to print all my sheets, but I guess
I've always been a little afraid of it to make changes. I guess I
figure I'll screw up a formula when I'm trying to change the border in
a cell.

Thanks again - I knew the board would come through for me!