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.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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:-
Switch between worksheets: CtrlPgDn or CtrlPgUp
Switch between workbooks: CtrlTab or CtrlShiftTab
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!
To cycle between sheets press Option + (Left or Right Arrow)
Sub ShowAllSheets() Application.CommandBars("Workbook tabs").ShowPopup End Sub
Close the window and use Alt+F8 to open the macro running window
ShowAllSheets and options on the side
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?