1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

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.

The keys used are the CTRL key plus either the PGUP (page up) or the PGDN (page down) key



Example - Switch Between Worksheets in Excel

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.