Is there any shortcut to iterate through Excel's worksheet tabs?
Solution 1
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:-
Solution 2
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 numpadSwitch between workbooks: CtrlTab
Solution 3
For mac OSX:
To switch between tabs in a worksheet: Fn + Command + up/down!
Solution 4
To cycle between sheets press Option + (Left or Right Arrow)
Solution 5
Do this:
- Use Alt+F11 to add a new module
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 sideAdd shortcut.
Related videos on Youtube
B Faley
Updated on September 18, 2022Comments
-
B Faley over 1 year
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.
-
B Faley over 12 yearsThis is great! Isn't there any way to do this without using mouse?
-
HikeMike almost 11 yearsslhck writes it's
Ctrl
instead ofCmd
-- could you specify which version of Excel your answer refers to? Maybe it changed? -
Karan almost 11 years@DanielBeck: Nothing's changed, in the Windows version at least. My guess is Matt is using a laptop keyboard with a typically weird layout that requires you to press Fn to change the behaviour of other keys. slhck's answer is sufficient IMO.
-
HikeMike almost 11 years@Karan There's no
Command
key on Windows computers (the equivalentWindows
key not being used for program keyboard shortcuts), and every Mac has bothCommand
andControl
keys. TheFn
is needed to makeArrow
keys intoHome/End/PgUp/PgDn
as shown in slhck's answer. -
Karan almost 11 years@DanielBeck: Yes, I know Fn is used to change the behaviour of other keys, as I already said above. Perhaps in this case Ctrl and Command can be used interchangeably, and both
Fn + Ctrl + Up/Down
andFn + Command + Up/Down
do the same thing on a Mac keyboard? -
n611x007 about 10 yearsthere could be a very visible disclaimer that this is not keyboard
-
n611x007 about 10 yearshow, if, can these be remapped?
-
slhck about 10 yearsNot sure as I don't have Office (anymore). Maybe you can ask a new question about that?
-
Eddified about 10 yearsThey are interchangeable. (Both work.) Tested on OS X 10.9.2 "Mavericks" with Excel 2011 v 14.3.9
-
Jayden Lawson about 7 yearsWorst shortcut ever. Might as well just use the mouse
-
Motsel over 6 yearsTip: if you use a trackpad, download the free BetterTouchTool app and map them to "TipTapLeft" and "TipTapRight"
-
Jason S over 5 years@JaydenLawson I think ctrl-alt-delete is just as bad or worse, and also vastly more widespread. As shick points out you can use fn-ctrl-up/down which has the advantage of fn and ctrl being together at the bottom far-left of keyboard and so easy to press with one hand without looking. The up/down arrows are also on the same line (at the bottom of keyboard) and are easy for me to find without looking.
-
Monero Jeanniton almost 4 yearswhat i was looking for
-
Adam about 2 years@DanielBeck Really late to the party here, but you can use either ctrl OR command along with fn and the up/down arrows. They both work.
-
Admin almost 2 yearsDoes not answer the question
-
Admin almost 2 yearsOS/X 2022: THIS is the right answer