How to Freeze Rows in Excel and Make it Sticky

how to freeze rows in excel

Many people use Excel to process data. This application has tons of functions so that users can process data quickly and automatically. Excel also has many features that allow users feel comfort while using it. One of the features is Freeze Panes. But how to use it properly as you intended?

Freeze Panes is a feature of Excel is used to freeze rows or columns so that allows users able to stay able to see certain rows/columns while scrolling the sheet. There are three options in Freeze menu, they are Freeze Top Row, Freeze First Column and Freeze Panes. There are some differences each other.

Freeze Top Row

Let’s get started with Freeze Top Row. You need to activate this option if only you want to freeze the first row.

You probably want the first row of your table keep visible while scrolling the sheet vertically, so you need to freeze the top row. This option will make the first row sticky and always visible although you scroll the sheet. In other words, the table header will keep visible while the table body can be scrolled.

For example, I have a table contains a few students with their scores at particular subjects.

table of scores

example table

You can activate this option by simply click View > Freeze Panes > Freeze Top Row. You don’t need to select certain cells at this option or put the excel pointer on a specific cell, because excel will freeze the first row of your sheet automatically.

excel freeze top row only

Choosing Freeze Top Row

This is the result looks like if you activate Freeze Top Row.

Freeze Top Row

Freeze Top Row

Freeze First Column

The second option is Freeze First Column. This option similar to Freeze Top Row, but freezing affect to the first column only.

You can activate this option by click View> Freeze Panes> Freeze First Column.

excel freeze first column only

Choosing Freeze First Column

The effect can be seen if only you scroll the sheet horizontally, from the left to the right or vice versa. You will see the first column get locked while table body get scrolled.

This is the result looks like if you activate Freeze First Column.

Freeze First Column

Freeze First Column

Freeze Panes

Third option is Freeze Panes. This option allow you to keep specific cells sticky. To use it, you need to put the excel pointer on a specific cell. Freeze Panes can be used to keep a few rows or columns visible, not only one.

For example, I have a table and I want to freeze the table header, No and Name. So, you need to put the pointer below the first row and after second column. So that the first row and the first two columns will be freeze or sticky, and the rest can be scrolled.

put the excel pointer on a specific cell

Put the excel pointer on a specific cell

Then you need to activate it by click View> Freeze Panes> Freeze Panes.

excel custom freeze

Choosing Freeze Panes

The effect can be seen if you scroll the sheet both vertically or horizontally.

This is the result looks like if you activate Freeze Panes.

Freeze Panes

Freeze Panes

Share with your friend..