Tip microsoft Excel spreadsheet split – It can be difficult to work with a Microsoft Excel spreadsheet documents a long and knowing what the row or column you are working on when scrolling past the top row or leftmost column.
To keep the rows or columns are locked in place to divide the spreadsheet by moving the mouse cursor over the icon in the top right or right scrollbar, scrollbar down. Once the correct position of your mouse cursor will turn into a double-arrowed cursor as shown in the figure. Hold your mouse and drag it down or to the right until the document is divided where necessary.
How do I unsplit?
If you want to remove the split, click-and-drag the split lines back to the top or the right of the spreadsheet to disappear and release the mouse button.