With one instance of Excel (maximised, for best effect), use File |
Open twice to open two different files. Then click Window | Arrange and
Horizontal and you will see two windows open within the one Excel
window. Each of these can be re-sized in the normal way to give you
other free space (grey area) within the Excel window, where you can
view other files if you wish.

Pete