Microsoft Excel for Mac now allows viewing mutiple worksheets side by side

If you use Microsoft Excel on Mac and have been waiting for the company to add the ability to view multiple worksheets side by side, there’s some good news.

In yesterday’s Microsoft 365 Insider blog, the company noted:

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.

Remember, the feature is available for those enrolled in Microsoft 365 Insider program. You can check the feature in action in the video embedded below:

Also read: Microsoft finally addresses a long-standing issue in Excel with Value Tokens

How to view multiple worksheets side by side in Excel for Mac

Viewing multiple worksheets in Excel for Mac is quite easy. You can simply follow the steps given below:

1. First, open a new or existing worksheet in Excel on your Mac device.
2. Now, choose the sheet you’d like to pop out in a new window.
3. Then, select the View tab, then New Window. Doing 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. Lastly, select the View Side by Side icon in Excel for Mac to view the worksheets on top of one another.

Microsoft also shared a few tips and tricks for Excel users on Mac while viewing multiple worksheets side by side:

• 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.)

Also read: Copilot in Excel is apparently extremely popular amongst users

Microsoft also mentions that the “View Side by Side feature is not currently findable via the Search feature.” Moreover, this update is available to Excel for Mac users running Version 16.97 (Build 25041535) or later.