How to freeze rows and columns in Excel

The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze column and row at once.

When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. This can be easily done by using the Freeze Panes command and a few other features of Excel.

How to freeze rows in Excel

Freezing rows in Excel is a few clicks thing. You just click View tab > Freeze Panes and choose one of the following options, depending on how many rows you wish to lock:

  • Freeze Top Row - to lock the first row.
  • Freeze Panes - to lock several rows.

The detailed guidelines follow below.

How to freeze top row in Excel

To lock top row in Excel, go to the View tab, Window group, and click Freeze Panes > Freeze Top Row.

This will lock the very first row in your worksheet so that it remains visible when you navigate through the rest of your worksheet.
Freeze top row in Excel

You can determine that the top row is frozen by a grey line below it:
Top row is frozen.

How to freeze multiple rows in Excel

In case you want to lock several rows (starting with row 1), carry out these steps:

  1. Select the row (or the first cell in the row) right below the last row you want to freeze.
  2. On the View tab, click Freeze Panes > Freeze Panes.

For example, to freeze top two rows in Excel, we select cell A3 or the entire row 3, and click Freeze Panes:
Freezing multiple rows in Excel

As the result, you'll be able to scroll through the sheet content while continuing to view the frozen cells in the first two rows:

The first two rows are frozen.


  • Microsoft Excel allows freezing only rows at the top of the spreadsheet. It is not possible to lock rows in the middle of the sheet.
  • Make sure that all the rows to be locked are visible at the moment of freezing. If some of the rows are out of view, such rows will be hidden after freezing. For more information, please see How to avoid frozen hidden rows in Excel.

How to freeze columns in Excel

Freezing columns in Excel is done similarly by using the Freeze Panes commands.

How to lock the first column

To freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column.

This will make the leftmost column visible at all times while you scroll to the right.
Freeze the first column in Excel.

How to freeze multiple columns in Excel

In case you want to freeze more than one column, this is what you need to do:

  1. Select the column (or the first cell in the column) to the right of the last column you want to lock.
  2. Go to the View tab, and click Freeze Panes > Freeze Panes.

For example, to freeze the first two columns, select the whole column C or cell C1, and click Freeze Panes:
Freezing multiple columns in Excel

This will lock the first two columns in place, as indicated by the thicker and darker border, enabling you to view the cells in frozen columns as you move across the worksheet:
The first two columns are frozen.


  • You can only freeze columns on the left side of the sheet. Columns in the middle of the worksheet cannot be frozen.
  • All the columns to be locked should be visible, any columns that are out of view will be hidden after freezing.

How to freeze rows and columns in Excel

Besides locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the same time. Here's how:

  1. Select a cell below the last row and to the right of the last column you'd like to freeze.
  2. On the View tab, click Freeze Panes > Freeze Panes.

Yep, it's that easy :)

For example, to freeze top row and first column in a single step, select cell B2 and click Freeze Panes:
Freezing top row and first column in Excel.

This way, the header row and leftmost column of your table will always be viewable as you scroll down and to the right:
Top row and first column are locked.

In the same fashion, you can freeze as many rows and columns as you want as long as you start with the top row and leftmost column. For instance, to lock top row and the first 2 columns, you select cell C2; to freeze the first two rows and the first two columns, you select C3, and so on.

How to unlock rows and columns in Excel

To unlock frozen rows and/or columns, go to the View tab, Window group, and click Freeze Panes > Unfreeze Panes.
Unlock frozen rows and columns in Excel.

Freeze Panes not working

If the Freeze Panes button is disabled (greyed out) in your worksheet, most likely it's because of the following reasons:

  • You are in cell editing mode, for example entering a formula or editing data in a cell. To exit cell editing mode, press the Enter or Esc key.
  • Your worksheet is protected. Please remove the workbook protection first, and then freeze rows or columns.

Other ways to lock columns and rows in Excel

Apart from freezing panes, Microsoft Excel provides a few more ways to lock certain areas of a sheet.

Split panes instead of freezing panes

Another way to freeze cells in Excel is to split a worksheet area into several parts. The difference is as follows:

Freezing panes allows you to keep certain rows or/and columns visible when scrolling across the worksheet.

Splitting panes divides the Excel window into two or four areas that can be scrolled separately. When you scroll within one area, the cells in the other area(s) remain fixed.
Splitting panes in Excel

To split Excel's window, select a cell below the row or to the right of the column where you want the split, and click the Split button on the View tab > Window group. To undo a split, click the Split button again.

Use tables to lock top row in Excel

If you'd like the header row to always stay fixed at the top while you scroll down, convert a range to a fully-functional Excel table:
Create a table to lock top row in Excel.

The fastest way to create a table in Excel is by pressing the Ctl + T shortcut. For more information, please see How to make a table in Excel.

In case you'd like to repeat top row or rows on every printed page, switch to the Page Layout tab, Page Setup group, click the Print Titles button, go to the Sheet tab, and select Rows to repeat at top. The detailed instructions can be found here: Print row and column headers on every page.

That's how you can lock a row in Excel, freeze a column, or freeze both rows and columns at a time. I thank you for reading and hope to see you on our blog next week!

You may also be interested in:


20 Responses to "How to freeze rows and columns in Excel"

  1. AQ says:

    Where would we be without freeze panes, thanks for your tips, it's definitely a good refresher.

  2. VSM says:

    How can I freeze first row and first column at a time?

  3. Mandana says:

    Thank you, clear and straight to the point.

  4. Brenda says:

    Thank you, clear instructions and staight to the point

  5. Shuvo says:


    need some help regarding only fixing any fixed row and columns of a sheet, is it possible to do so?

  6. Toni says:

    Hello and thanks for the tips.

    Is there any way to send a command from cmd or power shell to freeze first row?

  7. Katie says:


  8. Andrea says:


    thanks for the explanation.

    However, how would I freeze multiple columns (or the furthest right column) as well as the top row?

    Thank you.



  10. Kim says:

    How would i freeze the 1st columns or row for an entire workbook without going through each page to do so individually?

  11. patricia says:

    The freeze panes only freezes the top row now (excel 2016) so the program is getting worse.

  12. Kathleen says:

    Love this site. Always helps me.

  13. AshKing says:

    Good tips for freeze rows and column at same time.

  14. Es says:

    Thank you so much. It's very helpful and easy to understand your advice.

  15. kushal banerjee says:

    Thanks for your help!
    It worked

  16. Troy says:

    Thank you so much for your life-saving tutorial. This had helped me with my job tremendously.

Post a comment

Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard