How To Lock Only Certain Cells In Excel?

Select the entire worksheet by clicking the triangle at the top-left corner or pressing Ctrl+A

Right-click and choose Format Cells

Go to the Protection tab

Uncheck Locked

Click OK

Select the cells you want to lock

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

Click OK

Suggested for You

Trending Today