Microsoft 365 Roadmap
RM367423Excel: Enable "View Side by Side" on Mac
Summary
You can now quickly compare worksheets in the same workbook or in different workbooks by viewing them side by side with synchronous scrolling and reset window positioning on Mac.