switching between worksheets in Excel 2016 on Mac

Anonymous
2015-07-22T20:31:03+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments
Answer accepted by question author
Anonymous
2015-09-12T13:31:48+00:00

Dear all, 

Just hit  "Command + ~", thats work for me

Office 2016 version 15.12.3 (150724)

Was this answer helpful?

200+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2015-10-28T11:50:04+00:00

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.

Was this answer helpful?

80+ people found this answer helpful.
0 comments
Answer accepted by question author
Bob Jones AKA CyberTaz MVP 437.7K Reputation points
2016-07-02T12:17:29+00:00

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";

  • Switching between application windows,
  • Switching between open workbook windows, &
  • Switching between worksheets within a workbook

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.

Was this answer helpful?

0 comments

49 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-09-08T17:35:40+00:00

    Hi Jim,

    Can you tell us how to write or assign the keyboard shortcut on the Macro.  Your step 3.

    Was this answer helpful?

    0 comments
  2. Jim G 134.1K Reputation points MVP
    2015-08-15T18:45:47+00:00

    Here's what you can do:

    1. Open Excel 2016 to a new, blank workbook
    2. Tools menu > Macro > Macros
    3. Type the name SwitchWindows into the name field and assign a keyboard shortcut to the Macro, and then press Return
    4. The pathetic, disgusting mess of a Visual Basic Editor will display
    5. In the gray bar type ActiveWindow.ActivateNext

    6. Change the first line from

    Sub SwitchWindows() to Aub Auto_Open()

    1. It should now look like this in the editor:

    Sub SwitchWindows()

    activewindow.activatenext

    End Sub

    1. Click the Red dot in the upper left corner of the pathetic, disgusting mess of a Visual Basic editor to close the editor.
    2. From the File menu choose Save As
    3. In the Save As dialog switch the File format to Excel Add-in (.xlam)
    4. Give the add-in a name (I used NextWB.xlam) and then click the Save button. Remember where you saved it (somewhere in your Documents folder would be appropriate).

    You have now made your first Excel add-in. You are allowed to celebrate. 

    1. Go to the Excel Tools menu and choose Add-ins
    2. Click the Browse button
    3. Choose your saved add-in file and then click the Open button
    4. At this point you should be prompted whether or not you want to allow Macros to run, but I didn't get the prompt when I did this.
    5. Quit Excel

    When you open Excel the next time you you will get a Visual Basic for Applications Error. Click the Debug button, then click the Red button to close the editor. Then you should be able to use the keyboard shortcut you assigned to your macro to switch from one workbook to another. There is nothing wrong with the code, so you really shouldn't get the error. It's just one of the endless number of things wrong with Excel 2016.

    Was this answer helpful?

    0 comments