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