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.
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.