Question: how to make excel workbooks open in separate windows?
Answer: Click File > Open to open a couple of spreadsheets. Select the View tab. Select the View Side by Side option in the Window group. Alternatively, users can select the New Window option to open another spreadsheet in separate window.