Leading the way in Microsoft Office Development

Comparing workbooks side by side allows you to see the differences between two workbooks more easily.

This prevents you from having to merge all the changes into one workbook.

You can scroll through both workbooks at the same time to identify any differences.

Select (Window > Compare side by side with).

Select the name of the workbook you want to compare the active workbook to.