Learn about Ribon in Excel here. In this post, we shall learn how to split/divide the spreadsheet window. This helps us in viewing multiple distant contents of the spreadsheet.
To split the spreadsheet, first select a cell from where you want to split. In this case, we have selected D10.
Now go to 'VIEW' tab on the Ribbon and click on 'Split' command under 'Window' group (as displayed below).
The result screen would be like this. Notice the cross mark (vertical and horizontal bar) on the spreadsheet, now all 4 window will scroll separately.
To vertically resize the split window, place your mouse on the vertical bar. Your mouse cursor would change like below. Now drag by holding the mouse key.
Place your mouse cursor on the horizontal bar and your mouse cursor would change like below. Hold the mouse key and drag and the split window will be vertically resized.