ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut key to cycle through worksheets in the same workbook (https://www.excelbanter.com/excel-discussion-misc-queries/138332-shortcut-key-cycle-through-worksheets-same-workbook.html)

J K

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?



Ron Coderre

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?



J K[_2_]

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?



Ron Coderre

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?



J K[_2_]

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?



Ron Coderre

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?



Gord Dibben

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?




All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com