How To Compare Two Worksheets In Excel. In the list of open books, select the sheets you are going to compare. Go to the first workbook ‘book 1’.
If you have more than two workbooks open, excel displays the compare side by side dialog box. Web on the view tab, in the window group, click view side by side. Web how to use compare two sheets step 1: