How do I freeze a row in Excel?

Link to YouTube video

Freezing rows in Excel is very useful if you have more than “a screen’s worth” of data; i.e. if you scroll down it is helpful if you can still see the column headings when you are further down the data set.

Although without a bit of direction, it can be frustrating trying to freeze a row (know as Freeze Panes in Excel) if you don’t know exactly where to click, as it may not be where you expect.

In the example below, freezing the the row is easy because the header row is in row 1. All we need to do is click on the View ribbon, then click the Freeze Panes button, and then click Freeze Top Row:

But let’s say for example there are a few title rows or other data above the table, and the header row is not in row 1. Now we need to tell Excel in another way where the “panes” should be frozen; and that is always to the top and to the left of wherever you select, unless an entire row or column is selected. If an entire row has been selected, then it will freeze the row above, and if an entire column has been selected it will freeze the column to the left.

Or let’s say we want to freeze both the header row and the first column of the data, in that case we need to select a single cell, and that cell will be one cell below the header row, and one cell to the right of the first column, in this example the cell we would need to select before clicking “Freeze Panes” will be cell B6:

If you decide you’d like to un-freeze the panes, simply click the Freeze Panes button again, where the option will have changed to Un-freeze Panes.

Leave a Reply

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