Viewing multiple windows in Excel on Mac

Question

I am very familiar with viewing multiple windows both in different work books and for tabs in the same work book using view/new window and then arrange.  

However, since using the Mac version of Excel I keep encountering a problem whereby I can open as many new workbooks as I like, but I am unable to arrange them to view them side by side, because the arrange option is greyed out.

Please can you advise how to resolve this issue?

Answer 1

Hi Pat,

You can present the two sheets equally sharing the maximum space, please follow the steps below:

1. Open the two sheets, click Window on the top menu and chose arrange.

2. Choose Vertical and click OK.

3. Then the two sheets equally sharing the maximum space.

Regards,

Rosen

Answer 2

Hi PatB_365,

To determine whether background programs are interfering, please start up your Mac in safe mode, then open Word and check if there are some differences. (To start up Mac in safe mode, you can refer to Use safe mode to isolate issues with your Mac.)

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Also, we suggest you check if your Excel is the latest version. Please open Excel > click Help on the top menu > choose check for updates, then update your Excel to the latest version.

If the issue disappears, please refer to View multiple panes, sheets, or workbooks to use this function.

If the issue persists, please provide us with the information below:

1. Open Excel > click Excel on the top menu > About Excel, capture a screenshot about your Excel version and share with us.
2. Click Apple icon on the top menu > About this Mac, share your MacOS version with us.
3. What changes have you done before the issue appeared?
4. Please share a screenshot about*"but I am unable to arrange them to view them side by side, because the arrange option is greyed out.* ”

Regards,

Rosen

Answer 3

I think I may have resolved the issue, but still not ideal.

The original spreadsheet was displaying at maximum full screen. When I minimised, it allowed me to arrange the tabs.  However, it only does this on part of the screen and then I have to fiddle around to maximise the viewing area for the two sheets.  This is not ideal, as with the Windows version it normally presents the two sheets equally sharing the maximum space, which is preferable.

Perhaps this is a quirk of the Mac version?  If not, can you advise how to get this to happen automatically?

Regards

Pat