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