Home / Computers / Microsoft Excel

Splitting the Window

You can view different parts of the same worksheet at the same time by splitting the window. Splitting the window can be useful when you want to compare data in different locations, or copy date from one place to another.

You can split the window both horizontally and vertically:

1. To split the window horizontally, move the mouse over the split handle , the box at the top of the vertical scroll bar.

To split the window vertically, move the mouse over the split handle  at the right of the horizontal scroll bar

2. When the mouse pointer changes to a double horizontal line with arrows, click and drag the split handle to the middle of the screen.

You can also split the window by selecting Split from the Window menu. This splits the window into four quadrants.

To adjust the size of each of the panes, click and drag the border (split handle) separating them.

To return to a single window, double-click each of the split handles, or select Remove Split from the Window menu.