How To Lock Row In Excel?

Select the row you want to lock

Go to the Home tab

Click Format in the Cells group

Choose Lock Cell

Go to the Review tab

Click Protect Sheet

Set a password if desired

Confirm the protection settings

Click OK

To lock only one row while allowing others to edit, first unlock all cells, then lock the target row, then protect the sheet

Suggested for You

Trending Today