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.
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.
I can verify that CMD + ~ ( ⌘ + ~) does work in 2016.
I also note that if you go to help menu and type in keyboard shortcuts that there is no reference to window switching.
Shift-Command-Tilde (~) Is the Global window switching for OSX.
(⇧ + ⌘ + ~)
_________
Disclaimer:
The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.
Sorry, the instructions you provide make no sense to me at all, since I don't have a Windows group under the View tab. I can open two files that may or not be linked, size each window so that each occupies the full width of the screen, but only half of the height, move them so both are visible, so displaying a horizontal split between the files (is that what you mean?). Then I swap between the files, i.e. make each one active in turn, by using CMD + ~.
I am unsure if I have understood your question, or answered it, if I did understand it.