Question: how to open two excel sheet in one window?
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.