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