How To Lock Certain Cells In Excel?

Select the cells you want to keep editable

Right-click and choose Format Cells

Go to the Protection tab

Uncheck Locked

Click OK

Select the entire worksheet by pressing Ctrl+A

Right-click and choose Format Cells

Go to the Protection tab

Check Locked

Click OK

Go to the Review tab

Click Protect Sheet

Set a password if desired

Choose the allowed actions

Click OK

Save the workbook

Suggested for You

Trending Today