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

  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
Freeze Pane in Excel

 

By SC