can have two excel windows open same time?
View two worksheets in the same workbook side by side On the View tab, in the Window group, click New Window. In each workbook window, click the sheet that you want to compare. in the Window group on the View tab. Note: This option is available only when View Side by Side is turned on.