1. Computing

Excel Keyboard Shortcuts - Switch Between Worksheets

Switch Between Worksheets in Excel Using a Keyboard Shortcut

By

Keyboard Shortcuts - Switch Between Worksheets Excel

Keyboard Shortcuts - Switch Between Worksheets Excel

© Ted French

As an alternative to using the mouse, it is easy to use a keyboard shortcut to switch between worksheets in Excel.

Switch Between Worksheets Using a Keyboard Shortcut

Note: For help with this example, see the image to the right.

To move to the right:

  1. Press and hold down the CTRL key on the keyboard.

  2. Press and release the PGDN (page down) key on the keyboard.

  3. To move another sheet to the right press and release the PGDN key a second time.

To move to the left:

  1. Press and hold down the CTRL key on the keyboard.

  2. Press and release the PGUP (page up) key on the keyboard.

  3. To move another sheet to the left press and release the PGUP key a second time.

Other Keyboard Shortcuts

©2014 About.com. All rights reserved.