M$ Excel Question

Scrolling through worksheets

[limbo]

Anybody know a shortcut like the alt+tab command that lets you scroll through worksheets within an excel doc.

Thanks

Limbo

[curlykarl]

limbo

Do you mean page up and down?

Or what, I'm not following you :)

Karl

[roscoepico]

To scroll through the worksheets of the active Excel workbook, hold down the control key and press page down.

To scroll in the other direction, hold down control and press Page up.

[fatras]

ctrl - pg up/down 'll do it

beat me too it

[limbo]

Thanks guys

But that does not seem to work on my PC

I use Excel from office 2000 on XP - you think I am missing a trick?

[limbo]

When I use CTRL up/down it jumps the 'cell selector' to the top and bottom of the worksheet.

Have tried it on win2K and XP with excel home and proffesional. I Really need to know this fix! - It'll save me hours.

Ta

Limbo

[chris_f]

Searched the Index in the help for "shortcut keys" and got this (97 though)

Move to the next sheet in the workbookCTRL+PAGE DOWN
Move to the previous sheet in the workbookCTRL+PAGE UP
Move to the next workbook or windowCTRL+F6 or CTRL+TAB
Move to the previous workbook or windowCTRL+SHIFT+F6 or CTRL+SHIFT+TAB
Move to the next paneF6
Move to the previous paneSHIFT+F6

atob
c

[limbo]

Thanks Chris - infact thanks all of you.

Feeling a little stupid :) was using the cursors instead of the pageup/pagedown keys - I really should learn to read things more thoroughly!

Ta

Limbo

[chris_f]

no probs ... anytime