Excel : Freezing Panes

To freeze rows:

You may want to see certain rows or columns all the time in your worksheet, especially header cells. By freezing rows or columns in place, you'll be able to scroll through your content while continuing to view the frozen cells.

1. Click the View tab on the Ribbon.

2. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

3. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1, so we'll select row 2.

To freeze columns:

4. Select the column to the right of the column(s) you want to freeze. In our example, we want to freeze column A, so we'll select column B.

To freeze columns & rows:

5. If you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu.

Note: To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.

Excel : Split Worksheet Into Panes With Split Button

1. Select the row you want to insert the split pane above it firstly.

Tip: If you want to insert vertical split pane, you can select a column you want to insert the split pane left to it.

2. Then click View > Split, and you can see the split pane is inserted into the worksheet.

Tip: If you want to insert a cross split pane into a worksheet, select a cell that you want to insert horizontal split pane above and the vertical split pane left to, then click View > Split. 

Note: If you want to clear the split panes, just double click the pane you want to delete, then it will be removed.