- How do I lock only certain cells in Excel?
- How will you modify the contents of a cell if you made a wrong entry?
How do I lock only certain cells in Excel?
Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.
How will you modify the contents of a cell if you made a wrong entry?
Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.