Creating Multiple Windows (Views) for a Workbook

Sometimes, you want to view two parts of a worksheet at once. Or you want to see more than one sheet in the same workbook at the same time. You can accomplish either of these actions by displaying your workbook in one or more additional windows. To create a new view of the active workbook, click the View tab on the Ribbon and then click the New Window button. Excel displays a new window for the active workbook. To help you keep track of the windows, Excel appends a colon and a number to the workbook name in each window.
(Don't Forget):A single workbook can have as many views (that is, separate windows) as you want.

Displaying multiple windows for a workbook also makes copying information from one worksheet to another easier. You can use Excel’s drag-and-drop procedures to copy a cell, a range, or a chart.