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

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!


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