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.