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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keyboard shortcut for worksheet tabs 4
shortcut to toggle between 2 worksheets 11
Alternating between worksheets 9
Keyboard shortcut 3
Keyboard Shortcut Key for Switching between Worksheets In a Workbook 5
Chrome keyboard shortcuts 2
Keyboard Shortcut 3
Undocumented, awkward ALT+HOME shortcut? 24

Top