This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2007 - Navigate to Other Worksheets via the Keyboard

While you can navigate to other worksheets in the current Microsoft Excel 2007 workbook 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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Navigate to Other Worksheets via the Keyboard.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.