Protecting A Sheet In Google Sheets Workbook
When working with Google Sheets we might often work with others collaboratively. When collaborating on spreadsheets we might need to make sure that some information isn’t editable by others. We can set restrictions on spreadsheets or on a range of cells. Restrictions are set using tools similar to sharing documents.
We want to restrict any editing of the sheet labeled “District Level”.
To restrict edit access to this sheet, click on the triangle next to the sheet name and select the option to “protect sheet”.
A “protect sheets and ranges” panel will open on the right side. Provide a name to identify this restriction.
After setting the name, leave everything else the same and the sheet will be protected. No one else can edit this sheet. To take a look at the permissions, click the “set permissions” button.
A permissions pane will open and show that the sheet can only be edited by the owner.
Setting Custom Permissions
We can grant permission to other accounts so they can edit this sheet. Click on the pull down menu and select custom.
The pane will expand so we can provide the account information of someone that can edit this sheet.
Click the “Done” button to grant the account holder access to edit the sheet.
The permission is listed in the permission panel.
A lock icon appears on the sheet.
Click on the permission description to remove the protection from this sheet.
Click the trash can icon to delete this permission configuration.
Click the “Remove” button on the confirmation pane.