Question: how to open multiple excel files in one worksheet?
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.