If you don’t want people to change the content in a spreadsheet, you can protect it. 

When you protect a sheet, you can’t:

• Simultaneously lock the formatting of cells and allow users to edit input values

• Protect data with a password

1. Open a spreadsheet in Google Sheets.

2. Click Data > Protect sheets and ranges. A box will open on the right.

3. Click Add a sheet or range or click an existing protection to edit it.

4. To protect a range, click Range. To protect a sheet, click Sheet.

   • Range: To change or enter the range you’re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.

   • Sheet: Choose a sheet to protect. If you want a set of cells to be unprotected in a sheet, check the box next to "Except certain cells."

5. Click Set permissions or Change permissions.

6. Choose how you want to limit editing:

• To show a warning when anyone makes an edit: Select "Show a warning when editing this range." It doesn’t block people from editing, but they’ll see a message asking them to confirm if they really want to make an edit.

• To choose who can edit the range or sheet: select "Restrict who can edit this range." Choose:

  • Only you: Only you (and the owner if you’re not the owner) can edit the range or sheet.

  • Only domain: If you use Google Sheets for work or school, only people in your domain can edit the range or sheet. This option is only available when everyone in your domain can edit the spreadsheet.

  • Custom: Only the people you choose can edit the range or sheet.

  • Copy permissions from another range: Reuse the same permissions you set up on a different set of cells or sheet.

7. Click Save or Done.

To see protected cells, click View  Show  Protected ranges. A striped background will appear over the cells.