22
5
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.
Meysam
Posted 2012-01-29T10:11:54.390
Reputation: 630
5
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:-
Siva Charan
Posted 2012-01-29T10:11:54.390
Reputation: 4 026
54
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
slhck
Posted 2012-01-29T10:11:54.390
Reputation: 182 472
how, if, can these be remapped? – n611x007 – 2014-02-13T18:42:56.320
Not sure as I don't have Office (anymore). Maybe you can ask a new question about that? – slhck – 2014-02-13T20:55:17.003
7
For mac OSX:
To switch between tabs in a worksheet: Fn + Command + up/down!
Matt
Posted 2012-01-29T10:11:54.390
Reputation: 71
Worst shortcut ever. Might as well just use the mouse – Jayden Lawson – 2017-04-23T04:15:19.163
Tip: if you use a trackpad, download the free BetterTouchTool app and map them to "TipTapLeft" and "TipTapRight" – Motsel – 2017-09-13T17:47:53.257
@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. – Jason S – 2018-08-25T04:36:19.853
slhck writes it's Ctrl instead of Cmd -- could you specify which version of Excel your answer refers to? Maybe it changed? – Daniel Beck – 2013-06-14T20:14:38.020
@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. – Karan – 2013-06-14T21:52:40.280
@Karan There's no 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. – Daniel Beck – 2013-06-15T06:29:48.663
1@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 and Fn + Command + Up/Down do the same thing on a Mac keyboard? – Karan – 2013-06-15T15:15:54.857
1They are interchangeable. (Both work.) Tested on OS X 10.9.2 "Mavericks" with Excel 2011 v 14.3.9 – Eddified – 2014-03-26T05:25:37.690
1
To cycle between sheets press Option + (Left or Right Arrow)
user583074
Posted 2012-01-29T10:11:54.390
Reputation: 11
0
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.
user717890
Posted 2012-01-29T10:11:54.390
Reputation: 1
2This is great! Isn't there any way to do this without using mouse? – Meysam – 2012-01-29T10:47:37.357
5there could be a very visible disclaimer that *this is not keyboard* – n611x007 – 2014-02-13T18:42:21.520