How To lock cells In Excel

Locking cells in Excel can help you protect your data from accidental or intentional changes. Here are the steps to lock cells in Excel:

1. Select the cells you want to lock.
2. Right-click on the selected cells and choose “Format Cells” from the menu.
3. In the “Format Cells” dialog box, go to the “Protection” tab.
4. Check the box next to “Locked” to lock the selected cells.
5. Click “OK” to close the dialog box.

Now that you’ve locked the cells, you need to protect the worksheet to prevent anyone from making changes to the locked cells. Here’s how:

1. Click on the “Review” tab in the ribbon.
2. Click on “Protect Sheet” in the “Changes” group.
3. In the “Protect Sheet” dialog box, you can set a password if you want to prevent others from unprotecting the sheet without permission.
4. Make sure the “Protect worksheet and contents of locked cells” box is checked.
5. Click “OK” to protect the sheet.

Now, only authorized users can edit the unlocked cells on the worksheet.