Question: can you have two separate excel windows open?
Answer: View two worksheets of different workbooks side by side Open both of the workbooks that contain the worksheets that you want to compare. If you have more than two workbooks open, Excel displays the Compare Side by Side dialog box.