Keyboard Shortcut to View all Worksheets (Excel 2010)

[peteradamsims]

Hi,

Is there a keyboard shortcut to view all the worksheets in a workbook? I know how to right click on the <> arrows to view all the worksheets but wondered if there was a shortcut?

Thanks

Peter

 

[Eric Golf]

Hi,

Try Ctrl+PageUp or Ctrl+PageDown to cycle through worksheets.

Hope this helps,

Eric.

 

[peteradamsims]

Thanks Eric but I have a lot of worksheets so trying to work out a quicker way to quickly skip from one to another.

 

[igold]

Ctrl+Page Up/Down: Move to the previous or next worksheet

 

[Fluff]

If you right click one of the arrows to the left of the tabs, it will show a list of all sheets in the book.

 

[igold]

If you right click one of the arrows to the left of the tabs, it will show a list of all sheets in the book.

Wow @Fluff, I can now say that I honestly learned something today.

 

[Fluff]

That's what we're all here for

 

[peteradamsims]

If you right click one of the arrows to the left of the tabs, it will show a list of all sheets in the book.

Thanks for the reply Fluff but as mentioned I know how to do this....guessing there is no such keyboard shortcut.

Peter

 

[Fluff]

Apologies, miss-read you post.
As far as I know there is no keyboard shortcut.

 

[peteradamsims]

Apologies, miss-read you post.
As far as I know there is no keyboard shortcut.

No problem.

I guess there isn't a way to write a macro to do it or create a formula (by replacing with a less used keyboard shortcut)?