keyboard shortcut between worksheets?

C

Chris Hedlund

Can anyone tell me of a keyboard shortcut that would alternate me through
the worksheets in an Excel workbook similar to the way ALT+TAB moves me
through running applications?

Thank you.
 
R

RagDyer

<Ctrl> <PageUp>
<Ctrl> <PageDown>
--
HTH,

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

Lencastre

What about if the sheets aren't next to each other, like the first and
third from last?
Crtl+PgUp only switches between sheets that are right next to each
other.
 
A

Anne Troy

If you want to be able to navigate sheets that aren't next to each other,
then perhaps add some named ranges and use Ctrl+G or use some hyperlinks to
other sheets for navigation.
************
Anne Troy
www.OfficeArticles.com
 
D

David McRitchie

K

Kyler J

Is there any way to perform this task when the sheet is protected? I'm new
to protecting sheets, and I've noticed that the shortcut key function to move
between pages no longer works when the sheet is protected.

Any help is appreciated!
 
D

Dave Peterson

I protected some worksheets and it still worked ok.

I also tried protecting the workbook and that didn't make a difference, either.
 
Top