How to Protect a Worksheet in Google Sheets

The collaboration feature in Google Sheets makes it easier for a group of people to work on the same file. But if you have shared your file with others, you might not want them to be able to change some of the information found in that file.

Fortunately Google Sheets provides an effective way for you to achieve this by setting permissions for a particular worksheet in that file. Our guide below will show you how to protect a sheet in Google Sheets so that others are unable to change it.


How to Prevent Others from Changing Data on a Worksheet in Google Sheets

The steps in this article assume that you already have a spreadsheet in Google Sheets, and that there is a worksheet in that file that you want to protect. Completing these steps will modify the permissions of that sheet so that only you will be able to edit it.

Step 1: Sign into Google Drive at and open the file containing the sheet that you wish to protect.


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

click the data tab



Step 3: Choose the Protected data and ranges option.

choose the protected sheets and ranges option



Step 4: Click the Add a sheet or range option in the column at the right side of the window.

protect a sheet or range



Step 5: Click the Sheet tab, select the worksheet that you wish to protect, then click the Set permissions button.

choose the worksheet to protect



Step 5: Choose the Restrict who can edit this range option, select the Only you option, then click the Done button.

how to protect a worksheet in google sheets



Now the only person that can edit the specified worksheet is you.


Is there a file in your Google Drive account that has a file name which isn’t helpful? Find out how to change a file name in Google Sheets and make your spreadsheets easier to identify in your Drive.