Google Sheets There is no "Protected Sheets and Ranges" option under the Data menu.

  • Jay Sprout
    Asked on April 29, 2022 at 12:22 PM

    There is no "Protected Sheets and Ranges" option under the Data menu.

    Page URL: https://www.jotform.com/blog/how-to-lock-cells-in-google-sheets/
  • Parker JotForm Support
    Replied on April 29, 2022 at 2:26 PM

    Hello Jay,

    Thanks for contacting Jotform Support.

    When I viewed a Google Sheet, I was able to see the Protected Sheets and Ranges option on my sheet.

    1651256625 626c2d31b037c Screenshot 10

    If you're not seeing this it may have something to do with your account or how the sheet is shared with you. You'll want to contact Google for help with figuring this out though as we're very limited in what we can help with here as Google Sheets is not our platform.

    Let us know if you have any questions about Jotform.