Filter matching rows
Filter different rows
Display only rows present in both excel files and exclude new (removed) rows
Hide rows that have corresponding row on the other sheet. Display only different records on both sheets.
Extract matching rows
Extract different rows
Extract and save rows that has a corresponding row in other excel file.
Save on the third worksheet rows that doesn't have a matching row on the corresponding sheet.
Compare sheets by key columns
Compare VBA code and forms
Define Primary Keys columns and rows on your worksheets and compare them as structured tables, taking key values and field names into account.
Complete comparison of the Visual Basic projects in your Excel files. Compare code modules and forms with controls for differences.
Compare multiple Excel files
Mark differences with color
Enable 3-way comparison mode and compare three Excel files at once. Use this procedure in iterative mode to compare multiple Excel files for differences.
Permanently mark all changes you've found with background and text color to highlight them for future analysis.