This article may be out of date!
Visit the New Knowledge Center

How to Freeze Excel Headers

Objective:

  • How to freeze header rows in Excel

Environment:

  • Excel

Additional Information:

  • n/a

Procedure:

  1. Scroll to the top and make sure you see the row with the labels. Otherwise, you'll quickly notice one peculiarity - this option does exactly what it promises, it freezes the top visible row.
  2. Open the View tab in Excel and find the Freeze Panes option in the Window group.
  3. Click on the little arrow next to it to see all the options, and choose to Freeze Top Row (or to freeze the first column, depending on the way your data are organized

 

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality