Question

What is Split Worksheet? Write down the steps to split a worksheet.

Answer 1

Split your worksheet to view multiple distant parts of your worksheet at once. To split your worksheet (window) into upper and lower parts (pane), execute the following steps.

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).