1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Freeze Panes Step by Step Tutorial


2 of 5

Freeze the Top Row
Freeze the Top Row

Freeze the Top Row

© Ted French

Freeze the Top Row

  1. Click on the View tab.

  2. Click on Freeze Panes from the ribbon to open the features drop down list.

  3. Click on Freeze Top Row option in the list.
  4. .
  5. A black border should appear beneath row 1 in the worksheet indicating that the area above the line has been "frozen".

  6. Scroll down through the worksheet. If you scroll far enough, the rows below row 1 will begin disappearing while row 1 will stay on the screen.

©2014 About.com. All rights reserved.