compare excel worksheets for differences 2010

#Compare excel worksheets for differences 2010 plus#

Cells that exist only in main worksheet: Indicate the cells that are not in the overlap area and only exist in main sheet.

For example, if the used range of main worksheet is A1:D11, and the used range of lookup worksheet is B3:E10, the overlap area will be B3:D10.

Cells different in main sheet and lookup sheet: Indicate the different cells between two sheets in the overlap area of their used ranges.

Under the Mark results with color section, set colors for three different results:.So even if the results of two formulas are the same, as long as the formulas are different, the cells with the formulas will be marked. Under the Mark the formulas section, check Match Formula to compare formulas between two worksheets.Under the Mark results section, set the way you want the different cells to show: You can decide to change the background color, bottom border color or font color of the cells that are different as you need.Now, the two worksheets are displayed side by side, then, click Next to go to the Settings page: In the pop-up Compare Worksheets dialog box, at the left side, select a sheet from the active workbook as main worksheet to compare with a lookup worksheet at the right side, click the three-dot button to select another workbook, then select a sheet as the lookup worksheet.ģ.

#Compare excel worksheets for differences 2010 plus#

Click Kutools Plus > Worksheet > Compare Worksheets > Compare Worksheets.

To compare two worksheets and highlight different cells, please do as follows:ġ. With the Compare Worksheets feature of Kutools for Excel, you can quickly find the different cells between two worksheets. However, if there are mass data in your sheets, to find tiny little differences would be time-consuming and miserable for you. There are times when you need to compare data between two worksheets from different workbooks.