MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Locking Rows

Posted by Greg on August 08, 2001 5:25 AM

Is it possible to have the first row stay at the top even if I scroll down. I need something so that I can see my column headers that I put in Row 1 to even while editing Row 200. Is this possible.

Thanks. Greg

Posted by Ian bartlett on August 08, 2001 5:32 AM


Click on the cell beneath the row you want to stay visible, and to the right of any columns you want to remain visible. Then, on the menu bar, click 'Window', 'Freeze Panes'.

Remove the panes with 'Window', 'Unfreeze panes'.

Posted by Greg on August 08, 2001 5:54 AM

Perfect, exactly what I was looking for. Thanks a lot Ian.