This may help depending on what version you are on
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).