Excel® 2013 On Demand

Splitting a Worksheet into Panes

If you are working on a large worksheet, it can be time consuming and tiring to scroll back and forth between two parts of the worksheet. You can split the worksheet into four panes and two scrollable windows that you can view simultaneously but edit and scroll independently using the Split button. As you work in two parts of the same worksheet, you can resize the window panes to fit your task. Drag the split bar between the panes to resize the windows. No matter how you display worksheets, Excel’s commands and buttons work the same as usual.

Split a Worksheet into Panes

Select the row, column, or cell location ...