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

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

Maybe something that would allow me to see all the tabs together and select one of them to switch to it.

5 Answers

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:-

3

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

2

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

10

To cycle between sheets press Option + (Left or Right Arrow)

1

Do this:

1. Use Alt+F11 to add a new module

2. Paste

   Sub ShowAllSheets() Application.CommandBars("Workbook tabs").ShowPopup
   End Sub

3. Close the window and use Alt+F8 to open the macro running window

4. Click on ShowAllSheets and options on the side

5. Add shortcut.