Is there any shortcut to iterate through Excel's worksheet tabs?

Right click on any bottom corner left arrow keys, you will see list of all sheets and select the required sheet on the workbook.

Refer my screenshot:-

enter image description here


Windows:

  • Switch between worksheets: CtrlPgDn or CtrlPgUp

  • Switch between workbooks: CtrlTab or CtrlShiftTab

OS X:

  • Switch between worksheets:
    FnCtrl or FnCtrl on a small keyboard
    Ctrl or Ctrl on a keyboard with numpad

  • Switch between workbooks: CtrlTab


For mac OSX:
To switch between tabs in a worksheet: Fn + Command + up/down!