How to freeze a row in Excel [Compare data or create a sticky Header Easily].

How to freeze a row in excel

In Excel you can’t know what’s and what’s not important in doing your daily work, but there are very important things to do while working for example renaming a spreadsheet or sheet, yet there is another thing we disregard that is very important and it is for sure time saving to “Freeze a row”.

You can also freeze a column, but it all follow the same process, so if you how to freeze a row there is no doubt that you either know how to freeze a column.

I have a bonus tip for you within this post!

Why freeze a row in Excel?

To freeze a row can do many things for you, it is sometimes very important.

  • If you Freeze a row is another way of creating Menu to avoid back to top things.
  • Freezing a row (or rows) can help you compare data as you go through the sheet.
  • It doesn’t waste your time, who doesn’t want to save time.

Simply, freezing rows eases the workflow for all types of data in Excel if you have masses of data you can handle quickly.

How to freeze rows and columns in Excel

Freezing rows

Freezing a single row

This freezes the first top row, the best thing in this is that there only three steps to follow to freeze the row:

  • Open Microsoft Excel spreadsheet with some data.
  • Go to the menu bar of Excel and click “View”.
  • Within “window” section just choose a drop-down of “Freeze Panels”.
  • Click on freeze the top row.
Freeze one top row in excel
Freeze one top row in excel

After following the above steps, you will see that the top row will stick to the top like a menu.

The best this of freezing top row as I have said it protects you from keep getting back to the top to check up on data or headers of your data.

Then we have seen how we can fix top row of sheet, but there can be a case where it is necessary to freeze more than one row. Let’s see that!

Other similar posts:

Freezing more than one row

Freezing more than one row can look like we did in one row but there are some variations within the process, this is how we freeze more than one row:

  • Select a cell of which row you would like to freeze.
  • Go to “Views”
  • Select Freeze Panes
  • Choose Freeze Panes again
Freeze more than one row
Freeze more than one row

What you should know about freezing many rows is that you can’t freeze one single which is not at the top, if you freeze a row other than the top (first row) will freeze all rows above.

How to unfreeze rows

So far we have seen how to freeze a single row and many rows, now let’s see how to reverse these actions back which is called “Unfreeze”.

You do it this way:

Head back to view tab, and click Unfreeze Top Row if you froze one row otherwise click Unfreeze Panels if they are more than one row.

Microsoft Office posts:

Bonus tip

The today’s tip is that you can’t only freeze a row but also a column, the process is very simple either.

  • Select a cell in the first column (Column A).
  • Go to ” View” tab
  • Select “Freeze First Column.

Again, it is also possible to freeze more than one column, either two or more like we did on rows, select any column you want and choose Freeze panes and Boom! All preceding columns are frozen.

Thanks for reading this post, I can’t go without asking you something:

After reading this post, did you find that you were missing something from not using Freeze Panels?

If you have an addition or want to ask a question, leave a note in the comment section below to share ideas. Cheers!

Join the ConversationLeave a reply

Your email address will not be published. Required fields are marked *





  1. Interesting,I must say.
    Thanks for the info