keyboard shortcut between worksheets?

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.

You mean like Ctrl+PageDown or Ctrl+PageUp?
************
Anne Troy
www.OfficeArticles.com

"Chris Hedlund" <chedlund@mwdata.net> wrote in message
news:uzYl9rN5FHA.3188@TK2MSFTNGP15.phx.gbl...
> 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.
>

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

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


"Chris Hedlund" <chedlund@mwdata.net> wrote in message
news:uzYl9rN5FHA.3188@TK2MSFTNGP15.phx.gbl...
> 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.
>
>

beautiful - thank you!



"Anne Troy" <ng@officearticles.com> wrote in message
news:uHv3tuN5FHA.3760@TK2MSFTNGP14.phx.gbl...
> You mean like Ctrl+PageDown or Ctrl+PageUp?
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Chris Hedlund" <chedlund@mwdata.net> wrote in message
> news:uzYl9rN5FHA.3188@TK2MSFTNGP15.phx.gbl...
>> 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.
>>
>
>

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.

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

"Lencastre" <bruno.lencastre@gmail.com> wrote in message
news:1131539158.244033.251970@g14g2000cwa.googlegroups.com...
> 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.
>

Or just hit ctrl-pgup or ctrl-pgdn multiple times???

Anne Troy wrote:
>
> 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
>
> "Lencastre" <bruno.lencastre@gmail.com> wrote in message
> news:1131539158.244033.251970@g14g2000cwa.googlegroups.com...
> > 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.
> >

--

Dave Peterson

You can use the navigation keys at left of tabs to go to last
and then select the one you actually want.

You can rightclick on any of the sheet navigation arrows and choose
"More Sheets" and select any worksheet from the list.
http://www.mvps.org/dmcritchie/excel/dialog.htm
http://www.mvps.org/dmcritchie/excel...m#anothersheet
Your (more sheets) list would work better if you have sorted your worksheet tabs
http://www.mvps.org/dmcritchie/excel...#sortallsheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lencastre" <bruno.lencastre@gmail.com> wrote ...
> 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.
>

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!

"Dave Peterson" wrote:

> Or just hit ctrl-pgup or ctrl-pgdn multiple times???
>
> Anne Troy wrote:
> >
> > 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
> >
> > "Lencastre" <bruno.lencastre@gmail.com> wrote in message
> > news:1131539158.244033.251970@g14g2000cwa.googlegroups.com...
> > > 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.
> > >
>
> --
>
> 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.

Kyler J wrote:
>
> 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!
>
> "Dave Peterson" wrote:
>
> > Or just hit ctrl-pgup or ctrl-pgdn multiple times???
> >
> > Anne Troy wrote:
> > >
> > > 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
> > >
> > > "Lencastre" <bruno.lencastre@gmail.com> wrote in message
> > > news:1131539158.244033.251970@g14g2000cwa.googlegroups.com...
> > > > 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.
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson