Question: how to open multiple excel files in one window?
Answer: Select File > Open to open the second workbook.
Select the View tab.
Select Arrange All.
In the Arrange Windows dialog box, make sure “Windows of Active Workbook” is NOT selected. Then, select whichever of the arrangements is required.