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 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.
Display original value and modified value in the same cell. Change this to display difference between values in the options.
Green and Red arrow icons indicate that value in this cell was increased or decreased. In addition to usual color formatting this gives you visual indication about tendency in the numerical values.
Update sheet with cells from other sheet (Merge)
Mark Differences with Color
Insert all different rows into other excel worksheet and update all modified cell values. In one click you can move million of rows!
Permanently mark all changes you've found with background and text color to highlight them for future analysis.