Protect Google Sheets from being edited

Collaborating with others on the real-time editing of Google Sheets spreadsheets is very productive, but with many people editing in the same spreadsheets, it’s possible to modify data that wasn’t meant to be altered.

In Google Sheets it’s possible to protect whole sheets or specific ranges, and specify who can make edits.

If you want to protect specific sheets of your spreadsheet, you can do so in your workbook. To protect a sheet, click the sheet’s tab at the bottom of your spreadsheet and select Protect sheet from the menu.

Click image to enlarge

Click image to enlarge

A dialog will open to allow you to change the permissions:

Click image to enlarge

Click image to enlarge

Only the owner of the sheet can set edit permissions for individual sheets. Your co-editors and viewers will still be able to see the data, but (according to the permission you set for each sheet) they won’t be able to edit or delete a protected sheet.

Remember, though, that if another user makes a duplicate of the protected sheet or copies the workbook, sheet protection will be lost in the newly made example.

To protect just a particular range in a shared spreadsheet, highlight the range, right-click, and choose Name and protect range from the menu.

Click image to enlarge

Click image to enlarge

In the dialog that subsequently opens you can modify the range (if you need to), give it a name and, if you want it protected, check the Protect box.

Click image to enlarge

Click image to enlarge

The final dialogue that opens allows you to set the required permissions for the range.

Click image to enlarge

Click image to enlarge