Shortcut for Next/Previous Worksheet

[Haus]

I'm trying to find a keyboard shortcut for selecting the next or
previous worksheet tab in a workbook. I've looked at the XL Help for
keyboard shortcuts and it states that "ctrl + page up/page down" will
move to next or previous worksheet. I've tried this key combination on
my iBook and it only takes me to the last cell of the column (cell
65536) or back to first cell in the column.

What am I missing here?

 

[CyberTaz]

Control+PgUp/Dn work fine here, but I'm not on a laptop. Try
Command+PgUp/Dn, which are not documented but have the same default
assignment. Or you may have to use a third key to make the Control key work
- I don't use a LT so I'm not sure, other than that a full kybd works
differently in some respects.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

I'm trying to find a keyboard shortcut for selecting the next or
previous worksheet tab in a workbook. I've looked at the XL Help for
keyboard shortcuts and it states that "ctrl + page up/page down" will
move to next or previous worksheet. I've tried this key combination on
my iBook and it only takes me to the last cell of the column (cell
65536) or back to first cell in the column.

What am I missing here?

On my Powerbook, the "Page up/Page down" keys are the same as the up-
and down-arrows, that only have the Page function with the fn key down.

So fn-ctrl-up and fn-ctrl-down work for me.

 

[Haus]

On my Powerbook, the "Page up/Page down" keys are the same as the up-
and down-arrows, that only have the Page function with the fn key down.

So fn-ctrl-up and fn-ctrl-down work for me.

Gave it a try and works! Thanks much. Tried a bunch of key combos
before my post but not that one.

 

[Geoff Lilley]

Gave it a try and works! Thanks much. Tried a bunch of key combos
before my post but not that one.

I like Option plus the left and right arrows for the same reason. But
that's just my 2 cents.

Cheers
Geoff

 

[JE McGimpsey]

I like Option plus the left and right arrows for the same reason. But
that's just my 2 cents.

I would too if I hadn't redefined it. I started using CTRL-PAGE UP/DOWN
long before I had a Powerbook that required the fn-key, so
OPT-Left/Right got used for other things.

Habits die hard...