How can I protect a sheet/range in Google Sheets?

 

  1. Open the Google Sheet where you want to protect a selection of the document
  2. Go to Data > Protected sheets and ranges...
  3. Select the appropriate Range/Sheet option and then provide the required information and click Set permissions
  4. Unselect the person(s) you want to prevent from editing that protected sheet/range and click Done
    1. Note: you must share the document with others before you can prevent them from making changes to a specific part of the document
Print Article