You can quickly compare two worksheets in the same workbook or in different workbooks by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time.
1. First, open two or more workbooks.
2. On the View tab, in the Window group, click Arrange All.
3. Select the desired arrange setting. For example, click Horizontal.
4. Click OK.
5. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both workbooks at the same time.