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 following steps.

1. Click the split box above the vertical scroll bar.

Click Split Box

2. Drag it down to split your window.

Split Worksheet

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.

View Distant Parts

4. To remove the split, double click the horizontal split bar that divides the panes (or drag it up).

Note: in a similar way, you can use the split box to the right of the horizontal scroll bar to split your window into a left and right pane. You can even split your window into four panes. Any changes you make to one pane are immediately reflected in the other ones.

3/8 Completed! Learn much more about worksheets >
Back to Top: Split   |   Go to Next Chapter: Format Cells