Freeze Panes in Excel

 

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

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 in Excel

2. Click Unfreeze Panes.

Unfreeze Panes

Freeze First Column

To freeze the first column, execute the following steps.

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

Click Freeze Panes in Excel

2. Click Freeze First Column.

Freeze First Column

3. Scroll to the right of the worksheet.

Result: Excel automatically adds a dark grey vertical line to indicate that the first column is frozen.

Freeze First Column Result

Freeze Rows

To freeze rows, execute the following steps.

1. For example, select row 4.

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

Click Freeze Panes in Excel

3. Click Freeze Panes.

Freeze Panes

4. Scroll down to the rest of the worksheet.

Result: all rows above row 4 are frozen. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen.

Freeze Rows Result

Freeze Columns

To freeze columns, execute the following steps.

1. For example, select column E.

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

Click Freeze Panes in Excel

3. Click Freeze Panes.

Freeze Panes

4. Scroll to the right of the worksheet.

Result: all columns to the left of column E are frozen. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen.

Freeze Columns Result

Freeze Cells

To freeze cells, execute the following steps.

1. For example, select cell C3.

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

Click Freeze Panes in Excel

3. Click Freeze Panes.

Freeze Panes

4. Scroll down and to the right.

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

Freeze Cells Result

Magic Freeze Button

Add the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.

1. Click the down arrow.

2. Click More Commands.

Customize Quick Access Toolbar in Excel

3. Under Choose commands from, select Commands Not in the Ribbon.

4. Select Freeze Panes and click Add.

Add Magic Freeze Button

5. Click OK.

6. To freeze the top row, select row 2 and click the magic Freeze button.

Click Magic Freeze Button

7. 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.

Lock First Row

Note: to unlock all rows and columns, click the Freeze button again. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.