iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To remove a protected sheet or range in Google Sheets, open the spreadsheet on a computer and choose Data > Protect sheets and ranges. In the side panel, click Cancel to show the existing rules, select the protection you want to remove, then click its delete control. You can remove a rule only if your account has permission to change it.
Remove a protected sheet or range
-
Open the spreadsheet in Google Sheets on a computer.
-
Choose Data > Protect sheets and ranges.
-
In the side panel, click Cancel to display the existing protection rules.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Select the protected sheet or range you want to unprotect.
#1 Best Overall
Sale![The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite](https://m.media-amazon.com/images/I/41AWmhmGFuL._SL160_.jpg)
The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite- The Google Workspace Bible: [14 in 1] The Ultimate All in One Guide from Beginner to Advanced Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite
- ABIS BOOK
-
Click the delete control for that protection.
These are Google’s documented steps for removing a protection rule. Google’s instructions for protecting, hiding, and editing sheets describe the same workflow.
If you can’t delete the protection
Sheet protection is governed by permissions. Spreadsheet owners control who can change protected ranges and sheets. Editors can manage protections, but cannot take permissions away from owners; viewers and commenters cannot change protection rules. If the delete control is unavailable or Google denies the change, ask the spreadsheet owner or a Workspace administrator to remove the rule or adjust your access.
Three related requests have different outcomes:
- Delete the protection rule: An authorized user removes the restriction from the original spreadsheet.
- Allow specific collaborators to edit: The owner or an authorized editor changes who may edit the protected sheet or range, while keeping the protection in place.
- Get an editable copy: Make a copy, if your access allows it, and work in that separate file. The original spreadsheet’s protection remains unchanged.
Protection is not a password or security boundary
Google says, “This shouldn’t be used as a security measure.” Protected sheets and ranges restrict editing; they do not encrypt data or keep it confidential. Google’s help explains that people may print, copy, paste, and import or export copies of a protected spreadsheet, and that a sheet cannot be protected with a password. Do not rely on sheet protection to hide sensitive information.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Remove protection with Apps Script
For authorized automation, Apps Script’s Protection class provides the remove() method to unprotect a range or sheet. The user running the script still needs edit permission for the file, and the script must be authorized. This is an automation route for users who already have the required access, not a way around the spreadsheet’s permissions.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
