Question: how to compare differences in two excel sheets?
Answer: Open Spreadsheet Compare.
In the lower-left pane, choose the options you want included in the workbook comparison, such as formulas, cell formatting, or macros. ... 
On the Home tab, choose Compare Files.