Split your worksheet to view multiple distant parts of your worksheet at once. To split your worksheet (window) into a upper and lower part (pane), execute the followingsteps.1. Click the split box above the vertical scroll bar.2. Drag it down to split your window.3. Notice the two vertical scroll bars. For example, use the lower vertical scroll bar to move to row 49. As you can see, the first 6 rows remain visible.4. To remove the split, double click the horizontal split bar that divides the panes (or drag it up).