If you need to compare two excel files for the differences between them, you might want to use a third-party tool. In this Excel tutorial, we are going to compare two Excel workbooks in a simple way. Here’s an easy way to do that using Excel.
Table of Contents
Different ways to compare excel data
Side by side comparison
1.Open both Excel files
2. Select ‘Tools’ -> ‘Compare…’ and then click ‘Start’ button
3. You can select which file you want to compare and which one is the original.
4. If you want to see the changes between the two files, you can choose the ‘Side by side’ option. That is why this method is known as side by side comparison.
Excel data comparison using compare window
1.Open both workbooks
2. Add a sheet to both workbooks (we’ll call them WorkbookA and WorkbookB)
3. Select the cell A1 in each sheet.
4. Click Compare on the Data menu. This will open the Compare window.
5. Use the dropdown menus to select the range of cells that you’d like to compare:
Excel data comparison using macro
1.Create two separate Excel workbooks
2. Create an add-in for the first workbook and create a new module in the second workbook.
3. Add a macro named “Compare()” in the add-in module
4. Code the “Compare()” function using “Module 1”
5. Create two modules in second workbook
