Comparing Two Sheets in one Workbook

• You can compare two sheets in the same workbook by creating a new window inside your document. To do this, click "New Window" in the View tab. Then, click "View Side by Side" and select the worksheets to compare.
  
  

Compare Sheets from Different Workbooks

• If the sheets you want to compare is in two separate documents, you can compare them both by opening both documents in the same window and choosing "Compare Side by Side" after using the "View Side by Side" option as described above.
  
  

Comparing Multiple Worksheets

• To compare more then two worksheets, open each worksheet that you want to view using the "New Window" option in the view tab. After all the worksheets are open, choose "Arrange All" on the view tab.