![excel file comparison tool excel file comparison tool](https://www.lifewire.com/thmb/6_yu8AzzulQNqXhwdb5rqTVm0aQ=/1920x1080/filters:no_upscale():max_bytes(150000):strip_icc()/007A-how-to-compare-two-excel-files-4690172-c6eee258dc174c6da3ef1a1064805250.jpg)
And the details of these differences are also listed. Now you can see the differences in the second workbook are highlighted. Select the two files to be compared by clicking the folder icons on the right side.ĥ. Then the Compare Files dialog box pops up.Ĥ. Click Start, search for Spreadsheet Compare, and click the Open button.ģ. When you want to detect the differences between two workbooks, this is the perfect tool for you.ġ. Suppose you prefer Excel to find the differences rather than yourself while comparing the two workbooks, let me introduce this method: Microsoft Spreadsheet Compare. By default, this option is usually activated automatically once you turn on the View Side by Side mode.
![excel file comparison tool excel file comparison tool](https://images.sampleforms.com/wp-content/uploads/2017/05/Rental-Equipment2.jpg)
√ Notes: To scroll two workbooks at the same time for easy comparison, please make sure that the Synchronous Scrolling option is turned on. Now you can analyze the data in two files side you side and find the differences.
![excel file comparison tool excel file comparison tool](https://compare-excel.com/wp-content/uploads/2018/04/Microsoft_Picture-10.png)
Click the OK button to arrange the two Excel workbooks side by side.
#Excel file comparison tool windows
To view the two Excel windows side by side vertically, Click Arrange All in the View tab. By default, the two workbook windows will be displayed horizontally.Ĥ. Go to the View tab, then click View Side by Side.ģ. Open the two workbook files you want to compare in Excel.Ģ. To compare two workbooks for changes and view the differences simultaneously, apply the View Side by Side function in Excel. Quickly compare two workbooks and mark the differences in just a few clicksĮasily compare two workbooks side by side and mark the differences with an amazing tool In this tutorial, we will illustrate four ways to compare two workbooks for differences.Ĭompare two workbooks side by side and highlight the differences For example, compare the previous and current versions of a workbook to find the differences, or find the changes your colleagues have updated in your workbooks. In our daily work, you may run into situations when you need to compare two Excel workbooks.
#Excel file comparison tool how to
How to Compare Two Workbooks for Differences?