It will freeze row or column when we scroll down excel sheet below or right top row or left column will remain fixed.

How to Freeze Panes in Excel:

  1. Go to View option
  2. Click on Freeze panes option
    1. Unfreeze Panes: It will unfreeze all rows and columns.
    2. Freeze Top Row: It will freeze top row of sheet.
    3. Freeze First Column: It will freeze first column.
Freeze panes in excel
1.Freeze panes Option in excel

 

By SC