Custom: Only the people you choose can edit the range or sheet.This option is only available when everyone in your domain can edit the spreadsheet. Only domain: If you use Google Sheets for work or school, only people in your domain can edit the range or sheet.Only you: Only you (and the owner if you’re not the owner) can edit the range or sheet.To choose who can edit the range or sheet: select 'Restrict who can edit this range.' Choose:.To show a warning when anyone makes an edit: Select 'Show a warning when editing this range.' It doesn’t block people from editing, but they’ll see a message asking them to confirm if they really want to make an edit.Click Set permissions or Change permissions.If you want a set of cells to be unprotected in a sheet, check the box next to 'Except certain cells.' Range: To change or enter the range you’re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.Click Add a sheet or range or click an existing protection to edit it.Click Data Protected sheets and ranges.Simultaneously lock the formatting of cells and allow users to edit input values.Important: When you protect a sheet, you can’t:
