Tips & Techniques...

Excel 2003: Freeze Panes

Keep Row and/or Column headings from scrolling off the screen

• Click in the cell below the row and to the right of the column that you want to freeze (i.e. In the example displayed to the right, click B2 to freeze Row 1 and Column A)
  
  

• Select Window:Freeze Panes
  
  
• To Unfreeze - select Window:Unfreeze Panes