Chat with us, powered by LiveChat

Protect Spreadsheets

How to Protect Spreadsheets in Google Sheets

Protect Spreadsheets

Prevent unauthorized changes to data by protecting your spreadsheets. In a protected spreadsheet, none of its contents can be changed. However, it's also possible to set up the spreadsheet so that only certain cells and elements can be changed after it's protected.

Protect a Spreadsheet

  1. Click Data on the menu bar.
  2. Select Protected sheets and ranges.

    The Protected sheets & ranges pane opens on the right.

  3. Click Add a sheet or range.
    Protect spreadsheets.
  4. (Optional) Enter a description.
  5. Specify what you want to protect:
    • Range: Protect a cell or cell range from edits.
    • Sheet: Protect a sheet from edits. To leave a range of cells unprotected, check the Except certain cells box.
  6. Click Set permissions.
    Protect spreadsheets.
  7. Specify how you want to limit editing:
    • Show warnings when the spreadsheet is edited.
    • Specify who can edit the spreadsheet.
  8. Click Done.
    Protect spreadsheets.

The spreadsheet is protected and no changes can be made to the specified content.

Edit or Delete Protection

You can also edit which areas of your spreadsheet are protected, or delete protection from your spreadsheet altogether.

  1. Click Data on the menu bar.
  2. Select Protected sheets and ranges.

    The Protected sheets & ranges pane displays the protected ranges in this spreadsheet.

  3. Click the protected area you want to edit or delete.
    Protect spreadsheets.
  4. Edit the protection or delete it by clicking the trash icon.
    Protect spreadsheets.

The protection is edited or removed from the spreadsheet.

FREE Quick Reference

Click to Download