Although zooming on the worksheet can help you get your bearings in Excel 2013, it can’t split the worksheet into two separate windows so that you can compare their data on the screen. To manage this kind of trick, split the Worksheet area into separate panes and then scroll the worksheet in each pane so that they display the parts you want to compare.
Splitting the window is easy. Look below to see an Income Analysis worksheet after splitting its worksheet window horizontally into two panes and scrolling up rows 38 through 44 in the lower pane. Each pane has its own vertical scroll bar, which enables you to scroll different parts of the worksheet into view.
To split a worksheet into two (upper and lower) horizontal panes, you simply position the cell pointer at the place in the worksheet where you want to split the worksheet and then click the Split button on the Ribbon’s View tab (or press Alt+WS).
The key to the panes created with the Split button is the cell in the worksheet where you position the pointer before selecting this command button:
To split the window into two horizontal panes, position the cell pointer in column A of the row where you want to split the worksheet.
To split the window into two vertical panes, position the cell pointer in row 1 of the column where you want to split the worksheet.
To split the window into four panes — two horizontal and two vertical — position the cell pointer along the top and left edge of cell.
After you split the worksheet window, Excel displays a split bar (a thin, light gray bar) along the row or column where the window split occurs. If you position the mouse or touch pointer anywhere on the split bar, the pointer changes from a white-cross to a split pointer shape (with black arrowheads pointing in opposite directions from parallel separated lines).
You can increase or decrease the size of the current window panes by dragging the split bar up or down or left or right with the split pointer. You can make the panes in a workbook window disappear by double-clicking anywhere on the split bar (you can also do this by selecting View→Split again).