Is there any shortcut to iterate through Excel's worksheet tabs?

Question

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.

Siva Charan · Answer 1 · 2012-01-29 10:29:11Z

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

answered Jan 29 at 10:29

This is great! Isn't there any way to do this without using mouse? – Meysam رها در بند Jan 29 at 10:47

feedback

slhck · Answer 2 · 2012-02-09 08:05:33Z

up vote 4 down vote

Windows:

OS X:

Switch between worksheets:
Fn Ctrl ↓ or Fn Ctrl ↑ on a small keyboard
Ctrl ⇞ or Ctrl ⇟ on a keyboard with numpad
Switch between workbooks: Ctrl Tab

answered Jan 29 at 10:19

slhck
31.4k54162

	Your answer was great too, thank you! – Meysam رها در بند Jan 30 at 10:23
	`Alt Tab` switches between applications on Windows. To switch between workbooks use `Ctrl Tab` and `Ctrl Shift Tab`. – mischab1 Feb 9 at 2:06
	@mischab1 Thanks. In the future, please go ahead and edit an answer if you find something wrong! :) – slhck Feb 9 at 8:05

feedback

2 Answers