Here’s how to unlock Google Sheets protected ranges: Step 1 Or what if you find that you’ve granted all users edit access so the protected range no longer provides any protection? What if adding editors to a protected range is not enough to allow the required edits? The added users will now be able to edit the protected range Removing Protected Ranges (in 5 Steps) In the Range Editing Permissions dialog, under Restrict Who Can Edit this Range, choose the Custom option if it is not already selectedĪ list of spreadsheet editors will appear with checkboxes beside each to grant that user edit permissions to that range.Ĭlick the checkbox beside the user you want to add:Ĭlick Done to close the dialog when you’ve added all desired editors. Open the Data menu and click on Protected Sheets and Ranges:įrom the Protected Sheets & Ranges sidebar that appears, click on the protected range you want to edit Open the spreadsheet using an account that can edit the protected range, such as the spreadsheet owner’s account Step 2 Here’s how to add a user to a protected range: Step 1 This gives certain users access to edit the protected range without deleting the protection and can be useful if there are still certain users who should not be able to edit that range. Spreadsheet owners are able to edit and remove all protected ranges Adding Editors to a Protected Range (in 7 Steps)īefore jumping directly to removing protection in Google sheets, it’s important to consider if adding editors to that range might be a better option. If you aren’t sure what accounts have this access, you can always contact the spreadsheet owner and ask them to remove the protection. The only potential challenge is that you must be logged into an account which can edit that protected range in order to remove it. Protecting sheets and ranges in Google Sheets is a great way to prevent users from inadvertently making edits to those portions of the spreadsheet.īut sometimes you may find that these protections stop users from making necessary changes to the spreadsheet.Ī spreadsheet with too many protections can become impossible to use, so often it’s necessary to remove some or all protections to continue workingįortunately, removing protections in Google Sheets is quick and easy. Can you hide a sheet in Google Sheets from certain users?.How do I share Google sheets but not allow editing?.How do I protect a spreadsheet in Google Sheets?.Adding Editors to a Protected Range (in 7 Steps).

Protected view excel