How To Lock A Column In Excel?

Select the column 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

Make sure users cannot edit locked cells

Click OK

Suggested for You

Trending Today