Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers

up vote 3 down vote accepted

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

share|improve this answer
1  
This is great! Isn't there any way to do this without using mouse? –  Meysam Jan 29 '12 at 10:47
    
there could be a very visible disclaimer that this is not keyboard –  naxa Feb 13 at 18:42
add comment

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

share|improve this answer
    
how, if, can these be remapped? –  naxa Feb 13 at 18:42
    
Not sure as I don't have Office (anymore). Maybe you can ask a new question about that? –  slhck Feb 13 at 20:55
add comment

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

share|improve this answer
    
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 '13 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 '13 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 '13 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 '13 at 15:15
    
They are interchangeable. (Both work.) Tested on OS X 10.9.2 "Mavericks" with Excel 2011 v 14.3.9 –  Eddified Mar 26 at 5:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.