To reset the placement of the open windows, click the “View” tab in the Ribbon. Note that if the “View Side by Side” feature is enabled and you then resize or reposition either open workbook window, you can reset their placement. Then click the “Synchronous Scrolling” button in the “Window” button group to toggle it on or off.Ĭompare Workbooks in Excel – Instructions: A picture of a user comparing two workbooks in Excel side by side. To enable or disable synchronous scrolling, click the “View” tab in the Ribbon.

If disabled, you can independently scroll each workbook. If enabled, you can simultaneously scroll multiple workbooks being compared side by side.

Then click the “View Side by Side” button in the “Window” button group.Īfter clicking the “View Side by Side” button, you can then choose to enable or disable synchronous scrolling. To then compare them side by side, with each workbook taking an equal portion of the screen, click the “View” tab in the Ribbon. To compare workbooks in Excel, first open the workbooks to compare to each other.

This lesson shows you how to compare workbooks in Excel. Mac OS Monterey-Mojave Keyboard Shortcuts.

Compare files excel 2016