How to freeze or lock columns and rows in Excel 2010?
In Excel 2010, you can freeze columns or rows with the following options
- Freeze Panes
- Freeze Top Row
-
Freeze first column
How to freeze or lock columns and rows in Excel 2010?
1. To freeze or lock rows, select the row.
2. In the View tab of Microsoft Excel, click the Freeze Panes and select Freeze Panes.

3. To freeze or lock the columns, follow the same steps but instead of selecting the row, select the column…