This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Does anyone know how can I switch between different open worksheets in Excel 2016 on Mac with a keyboard shortcut?
It does not seem to work as it did in previous version or the way it works on Windows unfortunately.
Or is there a way to have two different Excels open on Mac simultaneously?
Thanks in advance for any help.
Best regards,
Peter
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Dear all,
Just hit "Command + ~", thats work for me
Office 2016 version 15.12.3 (150724)
While i have been using excel for over 25 years, only within the last two months have I been using it on a Mac. Clearly, excel is a much more robust program on a PC then a Mac.
Since using MSFT office (excel) on the Mac, the only way I found to switch between work books was CTRL + Tab works. Yesterday I installed Office 365 and while CTRL + Tab no longer works, CMD + ~ will switch between works books.
This rambling thread has intermixed feedback from many users over an extended period of time. It refers to numerous update levels of Office 2016 (most of which now are obsolete) running on 2 different editions of OS X and the comments jump between 3 different aspects of "switching";
In order to address a current issue it always is best to submit a new message stating all factors pertinent to your situation rather than adding to another conversation. In that way you can avoid getting tangles up in the melee. In fact, new postings to Answered questions often go unseen altogether.
Also, "Office 365" is not a version of the Microsoft Office software, it's Microsoft;s marketing name for their software subscription service. Make sure to indicate your actual version of Office as well as its specific update level.
Hi Bob,
I have the same problem. Been using MS Exel 2011 for mac for many years now and by default you switch between open worksheets by using ctrl tab.
That does not work in Excel 2016 and I can't find any information on the web how to get this function to work again.
It´s very frustrating since when you are working with several worksheets and are used to easy switch between them.
There is a guide here:
But it does not mention the shortcut.
Some answers would be very much appreciated.
Br
Marcus
For 2016 Control-Tab has been reassigned to selecting different screen elements.
The command that Control-Tab used to execute behind the scenes is available in Visual Basic for Applications. It is:
ActiveWindow.ActivateNext
If you are proficient in VBA and are willing to put up with the atrocious implementation of VBA in Office 2016, you could incorporate this command within an add-in that runs when you open Excel. The command can be assigned a keyboard shortcut.
BTW I should point out that the title of the question is misleading. It should have said "Switching Between WorkBOOKS.." instead of "...workSHEETS. There is also a problem switching between worksheets using VBA but you can still right click the lower-left corner of a workbook to display the Activate dialog that lets you choose a worksheet within a workbook.