Compare and merge Microsoft® Excel® worksheets, names and VBA Projects
General F.A.Q.
How to restore comparison options?
You need to use Restore Defaults button in the xlCompare Comparison Options.
This command restores default settings for comparison and difference highlighting.
Compare Excel Workbooks - comparison options
In the Comparison Options topic you can find more information about each option.