Keep your Heading Rows on the Screen when you scroll down in Excel

Click into the cell one cell below the rows you wish to freeze then

Click the View tab ribbon and choose the "Freeze Panes" icon.  

         
Then click the "Freeze Panes" option (first option)

Share this post