Freeze columns and rows in Excel


Excel 2013

  • Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).

    Screenshot of an Excel spreadsheet showing a row being selected
  • On the View tab, click Freeze Panes > Freeze Panes.

Excel 2016

  • Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5).  

    https://helixbing.blob.core.windows.net/stepimages/a0833e0a-13b5-4c9d-9371-37cf9f389b70.png
  • On the View tab, click Freeze Panes > Freeze Panes.