how to open excel files in two separate windows?
Select the View Side by Side Option 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.