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.