keyboard shortcut between worksheets?

Chris Hedlund

unread,

Nov 8, 2005, 10:08:23 PM11/8/05

to

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.

Anne Troy

unread,

Nov 8, 2005, 10:14:17 PM11/8/05

to

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

"Chris Hedlund" <ched...@mwdata.net> wrote in message
news:uzYl9rN5...@TK2MSFTNGP15.phx.gbl...

RagDyer

unread,

Nov 8, 2005, 10:15:59 PM11/8/05

to

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

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

"Chris Hedlund" <ched...@mwdata.net> wrote in message
news:uzYl9rN5...@TK2MSFTNGP15.phx.gbl...

Chris Hedlund

unread,

Nov 8, 2005, 10:43:17 PM11/8/05

to

beautiful - thank you!

"Anne Troy" <n...@officearticles.com> wrote in message
news:uHv3tuN5...@TK2MSFTNGP14.phx.gbl...

Lencastre

unread,

Nov 9, 2005, 7:25:58 AM11/9/05

to

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.

Anne Troy

unread,

Nov 9, 2005, 9:23:58 AM11/9/05

to

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.l...@gmail.com> wrote in message
news:1131539158.2...@g14g2000cwa.googlegroups.com...

Dave Peterson

unread,

Nov 9, 2005, 9:29:14 AM11/9/05

to

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

--

Dave Peterson

David McRitchie

unread,

Nov 9, 2005, 11:33:41 AM11/9/05

to

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/navigation.htm#anothersheet
Your (more sheets) list would work better if you have sorted your worksheet tabs
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#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.l...@gmail.com> wrote ...

J@discussions.microsoft.com Kyler J

unread,

Jan 31, 2006, 6:04:05 PM1/31/06

to

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

unread,

Jan 31, 2006, 6:39:12 PM1/31/06

to

I protected some worksheets and it still worked ok.

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

--

Dave Peterson