Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
J K J K is offline
external usenet poster
 
Posts: 1
Default Shortcut key to cycle through worksheets in the same workbook

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default Shortcut key to cycle through worksheets in the same workbook

I use these

Next sheet to the right:
[Ctrl]+[Page Down]

Next sheet to the left:
[Ctrl]+[Page Up]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Shortcut key to cycle through worksheets in the same workbook

I tried this and this did not work.

Any other ideas?

"Ron Coderre" wrote:

I use these

Next sheet to the right:
[Ctrl]+[Page Down]

Next sheet to the left:
[Ctrl]+[Page Up]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default Shortcut key to cycle through worksheets in the same workbook

I don't know what else to tell you.....

Per Excel Help (Keyboard Shortcuts topic)

CTRL+PAGE DOWN
Move to the next sheet in the workbook.

CTRL+PAGE UP
Move to the previous sheet in the workbook.

***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

I tried this and this did not work.

Any other ideas?

"Ron Coderre" wrote:

I use these

Next sheet to the right:
[Ctrl]+[Page Down]

Next sheet to the left:
[Ctrl]+[Page Up]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Shortcut key to cycle through worksheets in the same workbook

Dont know what I was thinking......this DID WORK!!! ( I was using the down
arrow)

Thanks for you help!

"Ron Coderre" wrote:

I don't know what else to tell you.....

Per Excel Help (Keyboard Shortcuts topic)

CTRL+PAGE DOWN
Move to the next sheet in the workbook.

CTRL+PAGE UP
Move to the previous sheet in the workbook.

***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

I tried this and this did not work.

Any other ideas?

"Ron Coderre" wrote:

I use these

Next sheet to the right:
[Ctrl]+[Page Down]

Next sheet to the left:
[Ctrl]+[Page Up]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default Shortcut key to cycle through worksheets in the same workbook

I'm glad that (finally) worked for you......and thanks for the feedback.



***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

Dont know what I was thinking......this DID WORK!!! ( I was using the down
arrow)

Thanks for you help!

"Ron Coderre" wrote:

I don't know what else to tell you.....

Per Excel Help (Keyboard Shortcuts topic)

CTRL+PAGE DOWN
Move to the next sheet in the workbook.

CTRL+PAGE UP
Move to the previous sheet in the workbook.

***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

I tried this and this did not work.

Any other ideas?

"Ron Coderre" wrote:

I use these

Next sheet to the right:
[Ctrl]+[Page Down]

Next sheet to the left:
[Ctrl]+[Page Up]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"J K" wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Shortcut key to cycle through worksheets in the same workbook

CTRL + Pageup and Pagedown


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 10:34:02 -0700, J K <J wrote:

What is the shortcut key that will allow you to cycle through worksheets in a
workbook that contains multiple worksheets?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut toggle between worksheets in the same workbook? Chris Excel Worksheet Functions 3 October 4th 06 09:59 PM
How do I keep result from 1 iteration cycle to use in next cycle? sgl8akm Excel Discussion (Misc queries) 0 July 27th 06 09:28 PM
How do I cycle through all of the worksheets DMB Excel Discussion (Misc queries) 1 January 9th 06 01:21 AM
How do I cycle through all of the open worksheets? DMB Excel Discussion (Misc queries) 0 January 9th 06 12:24 AM
What is the shortcut for switching between worksheets? DJALik Excel Discussion (Misc queries) 1 September 15th 05 05:55 PM


All times are GMT +1. The time now is 04:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"