Question: how to open multiple excel files in a single instance?
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.