Lock cells in a worksheet

1. Select the cells you'd like to lock.

2. On the Home tab, select the   Alignment Settings dialog launcher in the Alignment group.

3. On the Protection tab, check the Locked check box and then select OK.

4. Go to Review and select either  Protect Sheet or  Protect Workbook, and then apply password protection.

   Note: Cells are only locked when you have a password in place. To unlock, remove the password. 

Cells locked using the Excel desktop app are honored in the web app, but locking or unlocking cells isn't currently possible from Excel for the web. To lock cells, use the Excel Desktop App. 

1. Select the cells you'd like to lock.

2. On the Format menu on the top toolbar and select Cells.

3. On the Protection tab, check the Locked check box and then select OK.

4. Go to Review and select either  Protect Sheet or  Protect Workbook, and then apply password protection.

   Note: Cells are only locked when you have a password in place. To unlock, remove the password.