Question: how do i have two excel windows open at the same time?
Answer: Open both of the workbooks that contain the worksheets that you want to compare. On the View tab, in the Window group, click View Side by Side . ...  In each workbook window, click the sheet that you want to compare.