View multiple worksheets side by side in Excel for Mac

Hi, Insiders! My name is Prash Shirolkar, and I’m a Program Manager on the Excel team. I’m excited to share with you an improvement to Microsoft Excel for Mac that will allow you to easily look at two or more worksheets at the same time – just like you are used to in Excel for Windows!

View multiple worksheets side by side in Excel for Mac

Many of you collaborate on several Excel worksheets at a time, or reference one worksheet while working on another. Now, Excel for Mac supports the ability to view multiple worksheets from the same or different workbooks side by side, providing benefits such as:

• Enhanced productivity: Viewing worksheets simultaneously allows for seamless comparison and data analysis without the need to constantly switch tabs.
• Efficient workflow: This feature can speed up and streamline tasks like tracking changes, verifying data across different sheets, and consolidating information.
• Improved accuracy: By having multiple sheets open side by side, you can ensure consistency and minimize errors when transferring or referencing data.

How it works

1. Open a new or existing worksheet in Excel on your Mac device.
2. Select which sheet you would like to pop out in a new window.
3. Select the View tab, then New Window. This will open the selected sheet in a second window. To view worksheets from different workbooks, select New Window in one of the workbooks, then File > Open to find a second worksheet from another workbook.
4. Select the View Side by Side icon (two pieces of paper next to each other) to view the worksheets on top of one another.

Here’s a look at this new feature in action:

Tips and tricks

• If you rearrange the placement of the windows while working, you can select Reset Window Position to reset them back to viewing side by side.
• To scroll both worksheets at the same time, select Synchronous Scrolling. (This option is available only when View Side by Side is turned on.)

Known issues

• The View Side by Side feature is not currently findable via the Search feature.

Availability

This update is available to Excel for Mac users running Version 16.97 (Build 25041535) or later. 

Feedback

We’d love to know your thoughts about the View Side by Side feature in Excel for Mac! Send us your feedback by going to Help > Feedback.

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!