Filter data you compare

xlCompare allows you to define which data is taken into account when you compare workbooks.
Select View tab on the ribbon:
Filter tab
On this tab you can select data used for comparison:
  • Hidden Rows
  • Hidden Columns
  • Constant Cells (cells without formulas)
  • Calculated Values (value of the formula)
  • Formulas (text of the formula is compared)
On the Options tab you can define Formatting Comparison Options:
Options tab