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