How to Remove Worksheet Permissions in Google Sheets

Have you ever opened a spreadsheet to find that a collaborator has made a bunch of changes, such as merging a bunch of cells?

Adding permissions to a worksheet in Google Sheets is a great way to make sure that your document collaborators don’t inadvertently or intentionally change data that you don’t want them to change.

But occasionally you might protect a worksheet, only to find later that someone else actually does need the ability to edit it.

While you may have been able to add those permissions rather easily, it can be confusing to determine how you can remove them when the time comes.

Our tutorial below will show you how to remove the existing permissions from a worksheet that you had previously chosen to protect.

If you need a PDF or Excel version of your spreadsheet, then our article on how to download a Google Sheet to Excel will show you how to get one.

How to Unlock a Worksheet in Google Sheets

The steps in this article assume that you currently have a file in Google Sheets that contains a worksheet with permissions, and that you are the one who initially set those permissions. If someone else created the file and set the permissions, then you will need to contact them to have the permissions removed.

Step 1: Sign into your Google Drive at and open file with the worksheet whose permissions you wish to remove.

Step 2: Choose the Data tab at the top of the window.

google sheets data tab

Step 3: Select the Protected sheets and ranges option.

protected sheets and ranges menu

Step 4: Click the Show all protected ranges button in the column at the right side of the window.

show all protected ranges

Step 5: Choose the protected sheet that you want to unprotect.

select the protected range

Step 6: Click the trash can icon at the top of the column.

click the trash can icon to remove permissions

Step 7: Click the Remove button to confirm that you wish to remove protection from the sheet.

how to remove permissions from worksheet in google sheets

Do you have an Excel file that has a password that you want to remove? Find out how to unprotect a worksheet in Excel 2010 if you had previously protected it so that it couldn’t be edited.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy