If you want to view multiple Excel workbooks at the same time, execute the following steps.
1. First, open two or more workbooks.
See Also
Resize Excel Worksheet TABSGroup worksheets - Microsoft SupportHow to view sheets side by side in ExcelCompare two or more worksheets at the same time2. 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.
