Navigate to Other Worksheets via the Keyboard

Summary: Switch between worksheets in the active Excel 2007 workbook via keyboard shortcuts.

While you can navigate to other worksheets in the current Microsoft Excel 2007workbook via clicking on the sheet tabs located above the status bar, this may prove cumbersome if you are performing a good deal of data entry or worksheet navigation via the keyboard.

The following keyboard shortcuts jump to different worksheets:

Ctrl + Page Down: Switch to the next worksheet in the current workbook

Ctrl + Page Up: Switch to the previous worksheet in the current workbook

Note that these shortcuts will not “wrap around”, i.e. if you are at the last worksheet in a workbook and press Ctrl + Page Down, Excel 2007 will not navigate to the first worksheet in the given workbook.