switching between worksheets in Excel 2016 on Mac

Anonymous

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

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

Dear all,

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

Office 2016 version 15.12.3 (150724)

0 comments

Answer accepted by question author

Anonymous

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.

0 comments

Answer accepted by question author

Bob Jones AKA CyberTaz MVP 437.7K

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.

0 comments

49 additional answers

Anonymous

2017-02-27T11:19:19+00:00

I appreciate your prompt response. However, I am trying to use a horizontal split screen to access several workbooks and I am unable to since I don't have what the book is suggesting.

pg. 320 in GO! Step 2: "On the View tab, in the Window group, click Switch Windows and then click your file to make it the active worksheet. Then, Step 3 states: On the View tab, in the Window group, click Arrange All. Then click Horizontal

This is not possible as far as I can figure out.

Any ideas?

Thanks,

Kelly :D
Was this answer helpful?

0 comments No comments
Anonymous

2017-02-27T10:56:59+00:00

I open all the workbooks and scroll to the top of my screen to display WINDOWS, this displays a drop down menu enabling me to choose which workbook I wish to view. However, I am not able to link the workbooks and create a hyperlink like you can in the windows version. Looking for help with that myself.

Kelly :D

Certainly, Kelly, that switching technique works, but I prefer not to scroll; a quicker way that suits me best is to use Command + ~, as Alex Chambers has posted above.

Creating a hyperlink is easy. In the cell where you want to the link to appear, Insert / Hyperlink (or Command K), and then Select the file to which you want to link. The filename will appear in the cell, and clicking on that cell will jump you to that file, opening it if it is not already open. Is that what you wanted?
Was this answer helpful?

0 comments No comments