Teach Yourself Excel Lesson 19 - Freeze Panes

Nick's picture

Freeze Panes

This lesson is on how to freeze the panes. Freezing panes is about keeping the headings in view whilst being able to scroll down to enter data at the end.

To demonstrate why you want to do this:

  1. Download the starting sheet
  2. Choose "Review" menu on your ribbon
  3. Press "Unprotect Sheet"
  4. Select cell A1
  5. Press PAGE DOWN on your keyboard
  6. You'll notice immediately that you're unable to see the headings any more so you now have to guess what each column is.

To keep the headings in view:

  1. Select cell A2
  2. Press in sequence: ALT then W then F then F  (or select View => Freeze panes from your ribbon)
  3. Now Press PAGE DOWN
    • Headings will still be in view.


  • To get back to the 1st row of your data, press CTRL + HOME on your keyboard.
  • Where ever you are, that will bring you back

Your sheet should now look like this

Next Lesson: Teach Yourself Excel Lesson 20 - Sort Data

Training Video on how to freeze panes in Excel:

freeze-the-panes.xls20.5 KB