26

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.

Improve this question

5 Answers 5

Reset to default
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:-

enter image description here

Improve this answer
4
  • 2
    This is great! Isn't there any way to do this without using mouse?
    – B Faley
    Jan 29, 2012 at 10:47
  • 8
    there could be a very visible disclaimer that this is not keyboard
    – n611x007
    Feb 13, 2014 at 18:42
  • 1
    Does not answer the question
    – WestCoastProjects
    Jun 14, 2022 at 6:52
  • It does answer the second part of the question: "Maybe something that would allow me to see all the tabs together and select one of them to switch to it."
    – M. Justin
    Sep 14, 2022 at 22:57
63

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

Improve this answer
4
  • how, if, can these be remapped?
    – n611x007
    Feb 13, 2014 at 18:42
  • 1
    Not sure as I don't have Office (anymore). Maybe you can ask a new question about that?
    – slhck
    Feb 13, 2014 at 20:55
  • I've confirmed that either control or command (⌘) work for these shortcuts on macOS.
    – M. Justin
    Sep 14, 2022 at 22:59
  • To be super pedantic, Fn+Ctrl+<arrow> also works on a large keyboard.
    – M. Justin
    Sep 14, 2022 at 23:00
9

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

Improve this answer
10
  • 1
    slhck writes it's Ctrl instead of Cmd -- could you specify which version of Excel your answer refers to? Maybe it changed?
    – Daniel Beck ♦
    Jun 14, 2013 at 20:14
  • @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
    Jun 14, 2013 at 21:52
  • @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 ♦
    Jun 15, 2013 at 6:29
  • 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
    Jun 15, 2013 at 15:15
  • 1
    They are interchangeable. (Both work.) Tested on OS X 10.9.2 "Mavericks" with Excel 2011 v 14.3.9
    – Eddified
    Mar 26, 2014 at 5:25
4

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

Improve this answer
1
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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .