How to freeze panes in Excel

I would like to say hi!

When you scroll through a large table, you won’t have a sticky first column and you won’t know what certain columns refer to, that’s where Freeze Panes comes into play.

The Freeze Panes option can be found on the Browse tab.

  1. Click on the View tab.
  2. A little to the left you will see the Freeze Panes option.

How to Freeze Panes

To freeze the column pane to the left and top of a specific row, follow the instructions below:

  1. Click the first cell below the row you want to freeze and after the column, you want to freeze.
    You will see a lineup to the left to help you select this cell.
  2. Go to the View tab, then Freeze Panes.
  3. Click the Freeze Panes button.

How to freeze the top row

To freeze only the top row, follow the instructions below:

  1. Go to the View tab, then Freeze Panes.
  2. Click the Freeze Top Row button.

Your top row has suddenly become immobile.
Scroll down to see the rest of the worksheet.

How to freeze the first column

By following these procedures, you can freeze only the first column in the worksheet:

  1. Go to View and then Freeze Panes.
  2. Select Freeze First Column.

How to unfreeze panes

Follow the instructions below to unlock all rows and columns:

  • Select View.
  • Click on Freeze Panes.
  • Click on Unfreeze Panes from the menu.