Have you ever wanted to look at two tabs in an Excel 2007 workbook at the same time? It’s easy to do. Just click on the View tab and click the New Window button once for each added view you want:
Next, to bring some order to things, click the Arrange All button and select the arrangement that suits the number of views and/or workbooks you have open:
Tiled often works best if you have more than two views/workbooks open and want to see a part of them all at once. Otherwise, choose Horizontal or Vertical depending on what works best with your data. Cascade will arrange your windows staggered on top of each other, hiding the contents of all but the topmost view – though it can be helpful if you want to quickly click through them to locate the one you’re looking for when there are many open at once. If you want to constrain the windows you arrange to only include views of the active workbook, check the checkbox before clicking OK.
If you use multiple monitors and want to view an Excel workbook on a DIFFERENT screen, simply launch an additional instance of Excel and then drag it where you want it and open whatever workbooks that you want to review as you work. Just be careful when opening the same document in more than one Excel instance. Only work in one of them and use the other just for reference; otherwise you might save over your work!