Translations:Basic Excel/12/en

Navigate between worksheets

Often, there is more than one way to do something. Here, we demonstrate three methods:

  1. Click on the appropriate worksheet tab
    Navigate between worksheets by clicking on the appropriate worksheet tab
  2. Use shortcut keys
    • Press the CTRL and Page Down keys together (CTRL+PAGE DOWN) to move to the next worksheet. (CTRL+PAGE UP will take you to the worksheet immediately preceding the current one.)
  3. Use the pop-up menu from the worksheet tab controls
    • The worksheet tabs are useful when there are many worksheets in your workbook, and the tabs cannot all be viewed at once.
    • Use the tabs to bring the desired worksheet into view, then click on its tab, as described above OR
    • Hover the cursor over the righthand tab button, then right-click. A list of available worksheets will appear - click on the desired worksheet to move to it.
      Navigate between worksheets by selecting from list