70. Excel Tips - Freeze Panes

Nick's picture


Do you have a large amount of data that goes off the bottom of the screen ?

  • If you do, and you want to keep the headings in view, then this tip is for you

Here's a screen shot of our data in Excel:

freeze-panes

Here's how to keep the headings in view

  1. Select the leftmost cell in the row below the heading
    • in this case: A8
  2. Press in sequence:
    • ALT the w then f then f  (Excel 2007)
    • Window => freeze panes  (Excel 2003)

You will now be able to scroll down as far as you want without losing your headings:

freeze-panes

Download sheet to practise how to Freeze Panes in Excel

Training Video on how to Freeze Panes in Excel:

AttachmentSize
freeze-panes.xls22 KB