Split Panes

A very handy feature in Excel is the ability to view more than one copy of your worksheet and to be able to scroll through each pane of your worksheet independently.
You can do this by using a feature called Split Panes which will allow you to split your worksheet both horizontally and vertically.

When you split panes the panes of your worksheet work simultaneously.
If you make a change in one it will simultaneously appear in the other.

Horizontal Split

To create a horizontal split in your worksheet
Select the cell in column A where you wish the split to be placed.
Click the View tab.
In the Window group click Split.

Vertical Split

Select the column in row 1 where you wish the split to be placed.
Click the View tab.
In the Window group click Split.

Horizontal & Vertical Split

Select the cell where you wish the split to be placed.
Click the View tab.
In the Window group click Split.

Move The Split

If you want to move the split place your mouse over it, hold down your left mouse button and drag to where you want it to go.

Remove The Split

Select any cell.
Click the View tab.
In the Window group click Split.




Be the first to comment

Leave a Reply