To reset the placement of the open windows if you have the “View Side by Side” feature enabled and then resize or reposition either of the open workbook windows, click the “View” tab in the Ribbon.

Then click the “Synchronous Scrolling” button in the “Window” button group to toggle it on or off.

Optionally, to then enable or disable synchronous scrolling, click the “View” tab in the Ribbon.

Then click the “View Side by Side” button in the “Window” button group to compare them side by side, with each workbook taking an equal portion of the screen.

Then click the “View” tab in the Ribbon.

To compare workbooks in Excel, open the two workbooks to compare.

Then click the “View Side by Side” button in the “Window” button group again. To turn off the “View Side by Side” feature, click the “View” tab in the Ribbon. Then click the “Reset Window Position” button in the “Window” button group. 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. QuickBooks Desktop (PC/Windows) 2022-2015.Mac OS Ventura-Mojave Keyboard Shortcuts.

Excel for mac compare spreadsheets