Question: how to have 2 excel files open side by side?
Answer: Horizontally Split Screen Select the row which you want the split to be above and select (Window > Split). Using both a combination of vertical and horizontal split screens it is possible to see any two parts of a worksheet at any one time.