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.
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:-
Windows:
Switch between worksheets: CtrlPgDn or CtrlPgUp
Switch between workbooks: CtrlTab or CtrlShiftTab
On Logitech Mx Keys Mini, you can shift tabs using CTRL+FN+UP/DOWN arrows.
macOS:
Switch between worksheets:
FnCtrl↓ or FnCtrl↑, or
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!
Ctrl
instead of Cmd
-- could you specify which version of Excel your answer refers to? Maybe it changed?
Command
key on Windows computers (the equivalent Windows
key not being used for program keyboard shortcuts), and every Mac has both Command
and Control
keys. The Fn
is needed to make Arrow
keys into Home/End/PgUp/PgDn
as shown in slhck's answer.
Fn + Ctrl + Up/Down
and Fn + Command + Up/Down
do the same thing on a Mac keyboard?
To cycle between sheets press Option + (Left or Right Arrow)
Do this:
Paste
Sub ShowAllSheets()
Application.CommandBars("Workbook tabs").ShowPopup
End Sub
Close the window and use Alt+F8 to open the macro running window
Click on ShowAllSheets
and options on the side
Add shortcut.