How to freeze a row in Excel

In order to freeze a row in Excel, the following are the simple steps:

  • Open your worksheet in Excel.
  • Select the desired row you want to freeze, for instance, if you would like to free raw 3, then please select raw 4 or column C4 in this example.
How to freeze a raw in Excel
  • Click on the “View” tab and then check “Freeze Panes”.
  • Then select “Freeze Panes.” This option will freeze the desired chosen row and all above it.
  • Under the frozen row, a horizontal line will appear, indicating that it has been frozen.
Freeze a raw in Excel