Toggle between open workbooks

[Aland2929]

I normally press [ctrl] and [tab] to toggle between different open workbooks. If I have more than 2 open workbooks, it only toggles between 2 workbooks, not 3 or more?
Thanks in advance.

[jewelsharma]

I've got Excel 2010 as well , and [Ctrl] + [Tab] cycles through all the open workbooks for me.

[shukla.ankur281190]

It should work. In the case, don't minimize the Book3.xlsx's window. Then you should be able to use Ctrl+Tab and Ctrl+F6 to switch between the book1,2 and 3.

Because Excel 2013 move to a single document interface, so there is no workbook title bar minimize, maximize, and close buttons. When you minimize the Book3's window in Excel 2013, the action will be treated as you have used the workbook title bar minimize button to minimize the workbook.

In Excel 2013, the buttons can be found here:

https://social.technet.microsoft.com...getfile/227313

If you use the workbook title bar minimize button in Excel 2010 instance, the same behavior can be reproduced.

[Aland2929]

Thanks for the reply - I am using 2016 and it only toggles between 2 workbooks?