Advertisement

Article

Excel sheet comparisons made easy

Nick

Nick

  • Updated:

Excel logoOne of the worst jobs in Excel is having to compare data in two spreadsheets. It can be a painstaking process to go through them both and look for things such as price differences and value variations. Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel. It basically allows you to search for differences without doing any of the hard work.

There is no need to even open the tables to be compared. Simply specify the files, tables or ranges of cells to be compared and choose the aligning parameters for comparison by rows or columns. Specify what you would like to compare: cell values or formulas and set the way of highlighting the different cells (background colour and/or the colour and style of the cell border). The program then proceeds to successfully find all the changes in the latest price list such as new products (highlighted in green) and the changed prices (cells with a red border). There’s no need to even run Microsoft Office – Compare Spreadsheets for Excel performs everything independently meaning your workload could be cut in half in a stroke.

Nick

Nick

Latest from Nick

Editorial Guidelines