Lock specific cells in Excel


Excel 2013

To lock cells for editing:

  • On the Review tab > Protect Sheet.

  • Type a password, and make sure that Protect worksheet and contents of locked cells is selected.

  • Click OK. All cells have the Locked formatting by default, so this will protect all cells. 

Excel 2016

To lock cells for editing:

  • On the Review tab > Protect Sheet.

  • Type a password, and make sure that Protect worksheet and contents of locked cells is selected.

  • Click OK. All cells have the Locked formatting by default, so this will protect all cells.