How To Lock Cells In Google Sheets?

Open your Google Sheet

Select the cells you want to lock

Right-click the selected cells

Click Protect range

Enter a description if needed

Click Set permissions

Choose who can edit the range

Select Only you or Custom

Click Done

To lock an entire sheet, click Data

Click Protect sheets and ranges

Select Sheet

Click Set permissions

Choose who can edit the sheet

Click Done

Suggested for You

Trending Today