Freeze Panes

 

Freeze Top Row | Unfreeze Panes | Freeze Panes

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

Freeze Top Row

To freeze the top row, execute the following steps.

1. On the View tab, in the Window group, click Freeze Panes.

Click Freeze Panes in Excel

2. Click Freeze Top Row.

Freeze Top Row

3. Scroll down to the rest of the worksheet.

Result. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.

Freeze Top Row Result

Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column.

Unfreeze Panes

To unlock all rows and columns, execute the following steps.

1. On the View tab, in the Window group, click Freeze Panes.

Click Freeze Panes

2. Click Unfreeze Panes.

Unfreeze Panes

Freeze Panes

To freeze panes, execute the following steps.

1. Select cell C3.

2. On the View tab, in the Window group, click Freeze Panes.

Click Freeze Panes

3. Click Freeze Panes.

Freeze Panes

Result. The region above row 3 and to the left of column C is frozen.

Freeze Rows and Columns Result

4. Unfreeze Panes.

To freeze rows, execute the following steps.

5. Select row 3.

6. On the View tab, in the Window group, click Freeze Panes.

Click Freeze Panes

7. Click Freeze Panes.

Freeze Panes

Result. All rows above row 3 are frozen.

Freeze Rows Result

Note: to keep columns visible while scrolling to the right of the worksheet, select a column and Freeze panes.