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.
I've just updated my MS Excel to 2016, and I'm dismayed by the lack of an easily discoverable way to move between worksheets that are widely separated. Since I regularly work with Workbooks that contain 40 or more worksheets, and I move around between those sheets freely, I miss the left & right arrows in the bar at the foot of the screen in Excel 2011 that enabled me to view worksheet tabs before choosing which worksheet I wanted to view on-screen. Now, it seems that I have to move between worksheets one at a time before I can view the one I really want to see; if this is more than a couple of sheets away from my current sheet, this is very time-wasting, and very frustrating.
Does anyone know of a way to view those tabs without opening all worksheets?
No, as I explained earlier in this thread, Full Screen is an OS X service which doesn't support toggling between document windows... You can switch between applications [Command+Tab] but when you do it automatically takes the current document window out of Full Screen.