This article explains how to quickly navigate Excel between worksheet tabs and across large worksheets using various shortcuts and cell references. Some methods, such as the Go To command, are accessible via keyboard shortcuts. These instructions should work for all versions of Excel for Windows. Any minor differences between versions are noted in the steps.
Shortcut to go to next and previous sheets in MS Excel
You can easily switch between worksheets in an Excel workbook by clicking the tabs at the bottom of the worksheets. However, it is a slow way to do it, at least according to those who prefer to use keyboard shortcuts or shortcuts whenever possible.
To move right, hold down the Ctrl key on your keyboard.
Press and release the PgDn key on the keyboard.