Excel freeze row tutorial, Excel lock row tutorial

This is a step by step tutorial on how to lock a row in MS Excel 2007 and 2010 so the row is always visible when scrolling down the table.

  1. Go to View tab and select freeze panes.
  2. To freeze the top most row, select freeze top row. 
  3. To freeze multiple rows, select freeze panes.
Excel lock row tutorial


When you want to unfreeze the rows, just select unfreeze from the same freeze panes dialogue.

No comments:

Post a Comment