Viewing Different Parts of a Worksheet Simultaneousely
You can split a worksheet to show different parts at the same time and even make sure certain data is always visible.
Split a Worksheet: To view and scroll independently in different parts of a worksheet, it is possible to split a worksheet horizontally and vertically into separate panes. Splitting a worksheet into panes allows you to view different parts of the same worksheet side by side and is useful in instances when you want to paste data between different areas of a large worksheet.
The two right panes scroll together, as do the two lower panes
Keep Labels or Data Visible. To keep row and column labels or other data visible as you scroll through a sheet, you can elect to "freeze" the top rows and/or left columns. The frozen rows and columns don't scroll but remain visible as you move through the rest of the worksheet. The labels in the first row remain fixed while you scroll the rest of the worksheet vertically.
Note: It is not possible to both split a worksheet and freeze parts of a worksheet at the same time. Split or frozen panes do not automatically show up on each page when the sheet is printed. You need to specify any labels you want to print.