You can split an Excel sheet to view multiple parts of a document at once. To divide the workspace (window) into two parts, follow the suggested instructions:
- Click on the separator, which is located on the right above the vertical scroll bar.
- Drag it down to split the window.
- Notice the two vertical scroll bars. You can use the bottom one to, for example, go to line 49. In the meantime, the 6 lines at the top of the window will remain visible.
- To remove the divider, double-click on the horizontal line that divides the window (or drag it into place).
Note: To split a window vertically, use the splitter to the right of the horizontal scroll bar. You can even divide the workspace into four parts. Any changes made in one part of the window are immediately reflected in the rest.