Sunday, September 18, 2011

Freeze Panes in MS Excel 2007 (lock the leftmost column or top row)

If you work with spreadsheets with large size, and want the top row or leftmost column (which usually contains a description, number, date, name, etc) are always visible (because of  limited display screen of computer), we can use the Freeze Panes tool.

1. Open your Excel Spreadsheet Document
2. Highlight  the cell just below the second row and second column, (assuming the first row and first column to be locked)
3. Click the View Tab
4. Click Freeze Panes
5. Click Freeze Panes,  

the row and first column will lock, to see the result try moving to the far down or right side cell.


To restore to its original state (without freeze panes)
1. Click the View Tab
2. Click the Freeze Panes
3. Click unfreeze Panes.