Question: how to have multiple spreadsheets open in excel?
Answer: On the View tab, in the Window group, click View Side by Side .
In the workbook window, click the worksheets that you want to compare.
To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.