Compare 2 Worksheets In Excel 2010. Step 1 open the first excel spreadsheet. All worksheets include customer name/contact name/pilot.
As the result, you will have a difference report in a new worksheet. Using view side by side option to compare two excel sheets from different files and highlight. However, there are columns in each that only appear in that sheet.