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.
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.
This is the result looks like if you activate 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.
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.
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.
Then you need to activate it by click View> Freeze Panes> 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.