30 Advanced Excel Tips for 2026

Excel Champs / Excel Basics / How to Freeze Panes in Excel
By Puneet Gogia (Microsoft MVP)

How to Freeze Panes in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

The Freeze Panes option is used to lock rows and columns so they stay visible while you scroll anywhere in the spreadsheet. When you are working with huge data, it is difficult to compare values with each other.

But you can freeze the header or some specific rows and columns to keep them always visible at the top or on the left.

In this tutorial, I would like to share the steps to freeze the top row or first column, and the combination of rows and columns accordingly.

Steps to Freeze the Top Row in Excel

  1. First, make sure your header is in row 1. You don’t need to select anything, as “Freeze Top Row” always freezes the first visible row of the sheet.
  2. Next, go to the “View” tab on the ribbon, and from the “Window” group, click on the “Freeze Panes” command.
    header-to-freeze
  3. Now, in the freeze panes drop-down, select the “Freeze Top Row” option to lock the row.
    choose-freeze-top-row
  4. Here, you will notice a thin horizontal line below the header row that shows the area above it is locked.
    top-row-freezed

The keyboard shortcut is Alt ⇢ W ⇢ F ⇢ R to freeze the top row.

Freeze Multiple Rows at the Top in Excel

You can also freeze several rows in the worksheet as per your need. Here are the steps to do this:

  1. First, click the row number of the row just below the rows you want to freeze. (For instance, if you want to freeze the top three rows, then you must select the 4th row.)
  2. After that, on the “View” tab, click on the freeze panes drop-down and select the first option which is “Freeze Panes”.
    freeze-panes
  3. Now, scroll down the sheet and you’ll observe that all the rows above the 4th row will be visible on the top just as it is.
    above-selected-rows-visible

Freeze the First Column in Excel

To know how to freeze the first column in the spreadsheet, you must follow the steps below:

  1. You don’t need to select anything, as “Freeze First Column” always freezes column A (the first visible column).
  2. Again, in the Window group, click on the freeze panes drop-down.
  3. In the next step, you need to click on the “Freeze First Column” option.
    freeze-first-column
  4. In the end, the first column will freeze, which is shown by a dark vertical line.
    dark-vertical-line

The keyboard shortcut to freeze the first column is Alt ⇢ W ⇢ F ⇢ C.

Freeze Multiple Columns

  1. First, select the column just to the right of the columns you want to lock by clicking its letter. For example, if you want to freeze the first two columns (A and B) of your sheet, select column C.
  2. After that, go to the “View” tab > Freeze Panes > and click on “Freeze Panes” from the drop-down.
    freeze-multiple-columns
  3. Once you click on the freeze panes, the first two columns (A and B) will be locked, and these columns will be separated from the others by a straight vertical line.
    first-two-columns-freezed

Freeze Rows and Columns at the Same Time

To lock rows and columns together, select the cell just below the rows and just to the right of the columns you want to freeze, then go to View ➜ Freeze Panes ➜ Freeze Panes (or press Alt ⇢ W ⇢ F ⇢ F). For example, select cell B2 to freeze row 1 and column A, or C4 to freeze rows 1 to 3 and columns A and B.

Unfreeze Panes in Excel

  1. Just go to the “View” tab on the ribbon.
  2. Then, click on “Unfreeze Panes” in the Freeze Panes drop-down (Alt ⇢ W ⇢ F ⇢ F).
    unfreeze-panes
  3. Within a second, you’ll see all locked rows and columns convert back to normal.
    rows-and-columns-unfreezed

Point to Remember

  • The columns or rows which are locked always start from the top row and first column. It’s not possible to lock a row or column in the middle of the sheet.
  • Make sure that all the rows and columns you want to lock are visible on the worksheet.

Also, Freeze Panes is grey and not available in Page Layout view. Switch to Normal view (View ➜ Normal) to use it.

Frequently Asked Questions

Why is Freeze Top Row freezing the wrong row?

Freeze Top Row freezes the row that is at the top of the window when you click it. Scroll up to row 1 first (Ctrl + Home), then freeze it again.

How do I freeze panes on a Mac?

The options are on the View tab of the ribbon, just like Windows: Freeze Top Row, Freeze First Column, and Freeze Panes for the current selection.

Does Freeze Panes work when printing?

No, it only affects the screen. To repeat the header on every printed page, use Page Layout ➜ Print Titles and set “Rows to repeat at top”.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel