If you want to compare two excel worksheets on the same screen you can use “Compare side by side with” command on the window menu. Excel will arrange them horizontally.
If more than two workbooks are open, Compare Side by Side dialog box will give the names of all the workbooks so that you can choose the one you want to compare with the active workbook.
Below is the screen shot of “Compare side by side with” option where we have assumed two workbooks “A” and “B” are open.
However “compare side by side with” command can not be used to compare more than two workbooks. In that case we can use the “Arrange” option on the window menu and can choose the desired arrange option-Tiled, Horizontal, Vertical, or Cascading. When choosing the “Arrange” option make sure the “Windows of Active Workbook” check box is not selected.
Popularity: 5%