Monday, December 31, 2007

Tip # 11 Skip through your worksheets with a shortcut

When I'm working on many programs at once (yes, of course I'm a multitasker — what did you expect?), I use the keyboard shortcut ALT+TAB to move between open programs. (If you haven't tried this, do so now — it's a great Microsoft Windows® trick.)

However, this doesn't work when you're moving between worksheets in the same workbook. Don't despair; there are a couple of neat little shortcuts that handle the job quite nicely.

To move one worksheet to the right

Press CTRL+PAGE DOWN.

To move one worksheet to the left

Press CTRL+PAGE UP.

Now you can skip through those worksheets with lightning speed and amaze your friends and coworkers (if they're the type to be amazed by that sort of thing, of course).