Question: how to open multiple excel workbooks in same 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.