Sometimes you have a workbook with many worksheets that feed into a summary sheet.
It would be useful to see both the summary sheet and one of the other worksheets at the same time. Excel 2007 Excel 2010 and Excel 2013 make this a very simple exercise.
1. With the workbook open on the screen
2. Click on the View Tab
3. Select New Window from the Window Group