Freeze First Row
This feature could be used to freeze a particular row or header that you would need to refer every time while working on excel. In this option only the top row will freeze.
Freeze First Column
This feature could be used to freeze a particular column that you would need to refer while working on excel. In this option only the first column will freeze.
This feature could be used to freeze multiple rows, columns or both at the same time. However, this could be done only for the consecutive rows or columns.
If you have frozen the wrong rows and columns, then you could easily undo it by using “Unfreeze Panes” option. This would remove all the frozen rows and \ or columns in your excel.
Freeze panes versus Splitting Panes
Excel also provides you an excellent option to Split Panes which divides the window into different panes that each pane scrolls separately. This option is present in Excel Ribbon, View tab next to Freeze Option.
Is Freeze Pane option disabled?
If you have come across a case wherein the Freeze Pane option is disabled in your sheet, then it must be due to one of the following reasons:
This is a short movie about how to freeze a row on excel. Let’s watch it together. If you have any questions, please reply to this news video.