How to Freeze Rows and Columns in Excel 2016

  • MORE

 

When you're working with a lot of data, it can be difficult to compare one or more rows with others that are towards the bottom of the workbook. Excel's freeze panes feature solves this problem by letting you lock specific rows so they're always visible when you scroll. Here's how to do that in Excel 2016.

There are two quick steps to freezing or locking rows.

1. Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. In this example, we want to freeze rows 1 to 6, so we've selected row 7.

excel select row

2. Go to the View tab

3. Select the Freeze Panes command and choose "Freeze Panes."

excel freeze panes

That's all there is to it. As you can see in our example, the frozen rows will stay visible when you scroll down. You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them.

excel freeze panes scroll

If you want to unfreeze the rows, go back to the Freeze Panes command and choose "Unfreeze Panes".

excel unfreeze panes

Note that under the Freeze Panes command, you can also choose "Freeze Top Row," which will freeze the top row that's visible (and any others above it) or "Freeze First Column," which will keep the leftmost column visible when you scroll horizontally.

Besides allowing you to compare different rows in a long spreadsheet, the freeze panes feature lets you keep important information, such as table headings, always in view.

Add a comment
26 comments
  • Dr.A.K.Singh Says:

    Thanks for your nice video, its helps us to use Excle.

  • Phil Sukalewski Says:

    What a fracking PIA. The old method of dragging the line at the top down to the row(s) to freeze was WAAAAY better

  • Deepak Nagda Says:

    Thanks This information is very knowledge full

  • Anne-Kathrine Says:

    Thanks, this totally work!!! The older versions allowed us to freeze the colums/rows in a different way.
    And David Tatman you probably did it wrong it if it didn't work for you! Select the the cell that is a the cross section of the row and column you want frozen then go to freeze panels.

  • David Tatman Says:

    You need to take this off the web. 2016 does not have a generic freeze panes. You can freeze columns or rows but not both at the same time.

  • dejaf Says:

    SO helpful!

    this whole time ive been just highlighting the panes i wanted to freeze so it wasnt working. had no idea that i actually just had to click on the row below the row i wanted to freeze.

  • Muhammad Ashikuzzaman Says:

    Thanks, nice information. It just helped me.

  • Rakshith B D Says:

    Thanks for the help, that meant lot to me....

  • Balraj Jayia Says:

    Thank you for your help.it is a big help.

  • ProgentCT Says:

    For users having a problem locking, for example, the top 2 rows, make sure you're selecting the cells and not the entire row. So, to lock row 1 and 2 from cell A-Z select cell 3A to 3Z and click Freeze.

  • Anand warkade Says:

    thanks for this information. very helpful to improve my work in excel docs.

  • EmpressRose Says:

    Not working. I only have unfreeze panes, freeze top row, and freeze first column. I can't just click on freeze panes because then the drop down box opens and gives me me those three options. It just keeps freezing the top row. That's it. So much for getting my assignment done according to her instructions which is freezing the top 2 rows. Grrr

  • rnirawan Says:

    thanks for this information
    very helpfull

  • Adrian Says:

    Hey dude. This is very help. Easy to understand. God bless.

  • Adrian Says:

    Hey dude. This is very help. Easy to understand. God bless.

  • Avila Says:

    Hello,
    Could you please provide the steps to free multiple rows or columns.

  • fatuma k Says:

    When I freeze In my laptop does not function

  • Mangi Says:

    Thanks for the help .It help me lot to manage my fitness data.

  • Tits McGee Says:

    To freeze both rows and columns, select the upper left cell in the data you don't want to freeze. Then choose Freeze Panes from the menu.

  • Kaehae hae Says:

    What if I want to look A1 only so that no other user cannot type in that field

  • Anne Houck Says:

    Is it possible to freeze both rows and columns at the same time?

  • Me2016 Says:

    What if I want to freeze top row AND first left column?

  • Cmaves Says:

    What if i want to lock Row 6, 19, 21 & 28 etc. and not just the top row?

  • FREDDY Says:

    Thanks for the help I really got it.

  • Ruth Romero Says:

    This is very useful for me. Thanks a lot

  • ronaldmokaya Says:

    wow have got it praise be to God for you

Back to top