Highlight changes with: – Set a colour to highlight the changes.Count of Mismatched Cells – Self explanatory.Mismatched Column Name – Useful if the first row is a column name (for DB comparisons).Add Change Column to show – Adds a column to the spreadsheet to indicate changes.If this is unchecked, the cell values read are converted to strings and the changed to upper case and compared. Case Sensitive Comparison – self explanatory.Clear Existing Sheet Colours – Removes any cell colouring from the worksheet.Delete Change Column – Self explanatory.Start Row – Starts the compare from a particular row (useful when running long compares that have failed because of a mis-match).On the ‘Processing Options’ form, select the processing options that you want:.To compare two worksheets within the same workbook, select that workbook in both drop down list. On the ‘Select two spreadsheets to be compared’ form, select the Workbook(s) to be compared.Open the Workbook or Workbooks to be compared.The tool also allows you to automatically generate a very handy track-changes report:Īfter installing the plug-in from the link above, proceed as follows: The differences will be highlighted in yellow, like so:
Spreadsheet Compare is a free Excel plug-in that allows you to perform cell based comparisons between two workbooks. Even though Excel boasts a decent track changes feature (in Excel 2007-2010, it sits under the Review tab, and then Track Changes > Highlight Changes), we are still missing a Compare Document tool as in Word.
0 kommentar(er)
