Select the cell(s) in the row you want locked.
Right-click the selected cell(s) and choose Format Cells.
Go to the Protection tab.
Uncheck Locked.
Click OK.
Select the row(s) you want to remain editable.
Repeat the steps to uncheck Locked for those cells.
Select the row(s) you want locked (if not already locked).
Right-click and choose Format Cells.
Go to the Protection tab.
Check Locked.
Click OK.
Select the worksheet.
Go to the Review tab.
Click Protect Sheet.
Set a password (optional).
Ensure the allowed actions are set as desired.
Click OK.
