Excel Office 2016 Tabbing Shortcut

[Duffinator]

I have a iMac running El Capitan and just upgraded to Office 2016. I used to be able to use Control Tab to rotate between open spreadsheets but it no longer works. It still works in Firefox between tabs and Command Tab works for rotating through open programs. Is there a new shortcut for Excel?

 

[campyguy]

I'm not clear on what you're seeking so I'll offer both options. To be clear, a workbook is a "file" and spreadsheets are one or more layered data containers within each workbook.

To switch/rotate between open workbooks, use the Command-` shortcut to navigate in one progression, and Shift-Command-` (or, rather, Command-~) to navigate in the opposite progression.

To switch/rotate between open spreadsheets in a single workbook, use the Option-Right/Left Arrow.

 

[Duffinator]

To switch/rotate between open workbooks, use the Command-` shortcut to navigate in one progression, and Shift-Command-` (or, rather, Command-~) to navigate in the opposite progression.

That's what I was looking for thanks!