How to freeze header rows in Excel

To freeze or not to freeze

With new Excel capacity to hold a million rows and numerous columns with numbers, it is easy to lose the connection between the value and its meaning on line 26935. This is one of the reasons Excel keeps the commonsense "Freeze" feature for you. It allows you to keep track of the data you are looking at without having to scroll back and forth to see the column or row labels.

So, what's the button to click, and what are the pitfalls? Step number one is to look at your data and see if you need to lock just one row with the labels, several top rows, or columns.

How to keep your labels visible

If you have a usual table with one header row, the steps are very easy:

  1. Scroll to the top and make sure you see the row with the labels. Otherwise you'll quickly notice one peculiarity - this option does exactly what it promises, it freezes the top visible row.
  2. Open the View tab in Excel and find the Freeze Panes option in the Window group.
  3. Click on the little arrow next to it to see all the options, and choose to Freeze Top Row (or to freeze the first column, depending on the way your data are organized).

Freeze Top Row or First Column

Whenever you lock rows or columns, the Freeze Panes option turns into Unfreeze Panes for you to quickly unlock the row or column.

Lock several top rows, get hold of the columns

More and more often I come across tables that have several header rows. Those are complex structures, but they help you have some context to better understand the data. The question of freezing several rows can also come up when you compare one set of data to another, a couple of thousands rows away. The "Freeze top row" feature is obviously not very useful in this case. But the "Freeze panes" option is!
Here is how you do it:

  1. This moment is the key - select the cell just below the rows you want to freeze, and to the right of such columns if needed.
  2. Open the View tab in Excel and find the Freeze Panes option in the Window group.
  3. Click on the little arrow next to it to see all the options, and choose to Freeze Panes.

Freeze Panes option lets you lock several rows and columns

As always, this is not the end of the story. Because just like some users on this forum, one day you may find out it simply doesn't work for you. This may happen because you already have the top row locked. I don't know if I can call it a trick, the simple solution (and one thing to remember) is to unfreeze it first.

If any of the rows or columns are locked in the table, you'll see Unfreeze panes in place of the Freeze panes option. Peek at the option name before trying to lock the rows, and everything will work as you need it to.

Unfreeze the rows or column

Use this little handy feature to have the headers visible when you scroll and always know what figures you are looking at.

You may also be interested in

Category: Excel Tips

Table of contents

80 responses to "How to freeze header rows in Excel"

  1. Kevin says:

    I get how to "freeze pane" to lock down the header row, while I'm in the spreadsheet. My question is, How do I keep it that way, so when I send it to others that open it, the header row remains frozen?

    • James says:

      Using "Split" right next to the "Freeze Panes" option will allow you to have the same spreadsheet in different views, so you would be able to move the split so that you can only see the first row on one of the split screens, while still being able to scroll through the other version of the sheet.

  2. Bridget says:

    Thank you for the information!

  3. Abdul sani crc says:

    Very interested. I have tested it and it works im now enjoying it. Thanks

  4. abdul rehman says:

    I am facing a problem in attendance sheet, i need visible top row and left column while scrolling. page left and right up and down ,using excell 2013


    • Hello Abdul,
      When you click "Freeze panes", it freezes all rows above the selected cell and all columns to the left of it.
      Just select the cell to the right of the column you want to keep visible, and right below the row before clicking the button. E.g. select cell B2 to always have row 1 and column A on the screen.

  5. Phil says:

    Thank you, thank you, thank you!!! Super helpful information!

  6. Mila says:

    I was wondering how to freeze the first row but with a bunch of the comments, that are included in the first row? When I do it like you decribed previously, only first row of the comment is freezing but not the rest of it.

    • Hello Mila,
      Thank you for your question.
      This issue in Excel doesn't have a simple solution, but there is a workaround you can use.

      Click on the cell with a comment, go to Data tab and click on Data Validation. You can enter the information from the comment on the "Input Message" tab and select the check box "Show input message when cell is selected". Now whenever you click on the cell in the frozen row, this message will appear. You can move the box to any location you prefer. There is a nice video that describes the process:

      I hope you'll find this helpful.

  7. Sandeep says:

    Thank you

  8. Sultan says:

    Thank you so much. and thanks Google for leading me to you...

    may all your dreams come true

    wish you all the best...

    keep up helping ppl you beautiful lady

  9. Anonymous says:

    Thank you so much it worked well

  10. Danielle says:

    I have my top row frozen but as soon as I sort and filter then my frozen top row ends up somewhere other than the top. How do I keep it up at the top?

    • Hello Danielle,
      Please make sure you select the check-box "My data has headers" when sorting; you can see it if you select the "Custom sort" option on the Home tab or click on the "Sort" icon on the Data tab instead of clicking the standard Sort A->Z options.
      If this doesn't help, could you please specify what version of Excel you have and what steps you follow? I'll do my best to assist you.

  11. erin says:

    If I have the first 2 rows frozen, how can I make the first counted row start AFTER the frozen rows? I want the frozen rows NOT to be counted, and for my first counted row to start counting after the frozen row (that is, i want the third row to be the first counted row and say 1 on it, not 3). Thank you.

    • Hello Erin,
      I'm sorry, but there is no way to change the standard headings in Excel. You can only disable them on the View tab. If you want to number the rows below your headers, you can create an additional column and either start entering the numbers where you need, or use a formula in A3, e.g.

      and copy it down.

  12. Firstlady says:

    Please if i want to numbering a large volume of data without having to do it manually what could it be done with

  13. Firstlady says:

    What work can be used when you to passwords a document

  14. apple says:

    hi! i'm having a hard time with this freeze panel thing.i hope you can help me with this, coz everytime i open my file, i have to freeze them again..thanks in advance..

  15. RAVIRAJ says:


  16. Taindra LImbu says:

    Thanks for the amazing idea...
    so happy :)

  17. Taindra Limbu says:

    Thank you so much once again. I learned even more from all of yours comments. it helped me a lot
    thank you so much

  18. SRK says:

    Thank you sooooo much love you

  19. Meena says:

    Thanks alot

  20. Elize Mostert says:

    Thank you it worked :)

  21. krish says:

    Thanx!! It helps a lot....

  22. Kelly says:

    I am using Excel 2016 for Mac. I have a workbook set up with 12 monthly columns with a grand total column and an avg per month for each row (employee). I also have company wide totals at the end of each month column and then the avg for each month. The totals are unaffected by re-sorts, as are the row averages, but when I re-sort, my avg on each column gets moved up into the table. I had thought I could move the column avg to the top and then freeze the panes but they still get re-sorted. My header row with the month names is unaffected. Is there a way to set the column avg row as a header row as well, so they will remain at the top regardless of the sort?

  23. Becca says:

    I have frozen my top row; however, I need it on my next page below. For example, when I print, I need to see my frozen row on every page. How do I do that?

    • Hello Becca,

      Here are the steps you need to follow to print the top row on every page:
      - Go to Page Layout tab in Excel
      - Click on the "Print Titles" icon
      - Enter $1:$1 in the "Rows to repeat at top" field, or click on the icon in this field and select the top row
      - Click Ok

  24. Pinku says:

    Thank You So Much

  25. Rosemary Moretti says:

    Thanks so much. So easy.

  26. kishan says:

    tnx ...
    for solve my prblm..

  27. linda hammond says:

    Hello, I click on view tab but drop down has no freeze options?
    Where can I find please

  28. Jennifer says:


    I am trying to setup a Print Title on my spreadsheet. I know to go to "Print Layout" then to "Print Title" but hen I'm lost from there. I don't understand the formula's to enter there. Can you help me understand how to set this up?

    Thank you!

  29. vijayakumar says:

    super support thanks

  30. Makuach says:

    It was great. I learned what I have been looking for.

    Thank you.

  31. S.R.Ramesh says:


  32. Abi says:

    Thank you :)

  33. Nangyalai Nomyal says:

    Thank you very much. Very helpful information!

  34. Cathrene says:

    Hello Excel experts,

    I need help formatting my workbook.

    The sorted data tab is supposed to be formatted so that the same row appear at the top of each page. I just can't figure this out. Can you help?

    • Hello Cathrene,

      Freezing the top row is what does the trick if you work with the file. If you need to print it, here are the steps:
      - Find the Page Layout tab in Excel, click on the "Print Titles" icon
      - Enter $1:$1 in the "Rows to repeat at top" field and click Ok.
      I hope this helps!

  35. Paul says:

    Hi, just a thank you, what a great short/sweet tip site!! I found this page thru google to help me label the columns so they stayed visible as I scrolled through data, and then while blasting thru the comments I saw this tip about printing the column labels per page, AWESOME. Thanks so much Irina

  36. Nadeesha says:

    Thank You very much for your helpfull guide..

  37. Ayaa says:

    I have a problem with filter button in excel using VBA code. When I filtered the data, the header name of each column in the worksheet its does not appear. I just can't figure this out. Can you help me?

  38. Ashley says:

    Thank you kindly

  39. Basel Alyafi says:

    Thank you for the valuable info.
    I really needed to show the headers row down in the table and split is useful too.

  40. Igor says:

    I want to have my first row to be in bold and centered for example.
    I lock it from editing (I know how to do this).
    But after this how to select whole column by one click on top as usual.
    Locked row doesn`t give you ability to select whole column for editing
    Thanks in advance

  41. anonymous says:

    Thanks, I finally did how to fix it.

  42. rose says:

    Im using excel 13 and i merge the top row, and i freeze it. how can i make the text still visible when im scrolling it to the right?

  43. javid iqbal says:

    nice piece of information... i very thankfull to you guys for spreading & intimating this information...
    God Bless

  44. Michelle Forsmo-Shadid says:

    Thank you so much! This spreadsheet was making me crazy until I found this tip.

  45. kanhaiya jha says:

    thankq for help

  46. sharif shaik says:

    Thank you for your explanation.

  47. Oluwatosin Olorunfemi says:

    This is good. To every hard work there is a reward, I pray the Lord most high will reward you in Jesus name. You have tried you improve my excel knowledge.

  48. thank you says:

    thank you

  49. Anne Moriarty says:

    A MILLION thanks! This has been driving me crazy and now it's solved! I appreciate your solution.

  50. Devassy Felix says:

    I came across an excel that reflects the headers that we create on the Actual headings ie(A,B,C) in excel. The header in row 1 will reflect on the original heading of the Microsoft excel while we scroll down. there is no need of freezing the first row to see the header all the time. This will mirror on the headings. I tried to find this out a lot and couldn't can you help in finding this one?

  51. Mansuur Bey says:

    Thank you very much for posting this tip! It saved me a lot of time trying to figure this out.

  52. Matt says:

    Hi Irina,
    I am trying to have 2 cells in the same column frozen with 7 cells that are shown and can be scrolled with up to 50 cells. Basically I want a table that has a frozen top and bottom with 7 cells shown at once in between, but the 7 shown cells can be scrolled down to show up to 50 rows down, but only showing 7 at a time between the two frozen cells. How would I do this? Thank you for all the great info on excel you have shared. I look forward to learning more.

  53. Hello Matt!
    Excel allows "to freeze" only the rows at the top and the columns to the left.
    Maybe, the following advice on our blog will be more helpful:

  54. 20200422 says:

    Thank you!

  55. Chandrakant Sahu says:

    I have a exal file of 200 cloumn. I freeze collumn 1-2-3-4 but the it doesn't work it only freezing first 3 or 1-14 column. I tried many times, but same thing is happening. Why it isn't work?

  56. Tony says:

    Hi Irina

    I want to hide a column but keep the top row above it. Is this possible?

  57. Twanette says:

    How to I lock / freeze my first row in a drop down combo list button?

  58. Leo says:

    I have set of table in my sheet. How can i freeze the header of the first table and while scrolling down, the header of the second table should be freeze also once it reaches bottom of the header of the first table. and when i will scroll down, all rows will be visible again?

    Hope there is a way to make this, with your help.


  59. Sri says:

    Thank you! Was quite helpful

  60. Julie Rimington says:

    Thank you for this. Tried at least half a dozen other web pages (higher up the google search) before finding this one. Such a clear, simple explanation.

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)