Chat with us, powered by LiveChat

How to Freeze a Row in Excel

How to Freeze Rows and Columns in Excel

When you're working in large spreadsheets, it can be hard to know what you're looking at once you scroll away from the header rows and columns. To fix this problem, you can freeze part of the worksheet so that even when you scroll, the headings are displayed.

Freeze Rows

When you freeze panes, the rows above and columns to the left of the active cell are immobilized. In order to change the freeze point, you must unfreeze and freeze the cells again.

  1. Select a cell next to the row and/or column you want to freeze.

    If you select a cell in the first column, only the rows above it will freeze (no columns). If you select a cell in the first row, only the columns to the left will freeze (no rows).

  2. Click the View tab.
  3. Click the Freeze Panes button.
  4. Select Freeze Panes.
    Freeze Rows
  5. Scroll to verify the cells are frozen.
    Freeze Rows

The frozen cells are visible no matter how far you scroll.

Freeze the First Row or Column

When you freeze only the first row or column, it doesn’t matter which cell is selected when the freeze is applied.

  1. Click the View tab.
  2. Ciick the Freeze Panes button.
  3. Select Freeze Top Row or Freeze First Column.
    • Freeze Top Row Keeps the top row visible while scrolling through the worksheet.
    • Freeze First Column Keeps the first column visible while scrolling through the worksheet.
  4. Scroll in the worksheet to verify the freeze is applied.
    Freeze the First Row or Column

Unfreeze Panes

If you no longer need the cells in a spreadsheet to be frozen, you can unfreeze them at any time.

  1. Click the View tab.
  2. Click the Freeze Panes button.
  3. Select Unfreeze Panes.
    Unfreeze Panes