How to Lock a Sheet
in Google Sheets

Learn how to protect your data in Google Sheets by locking specific sheets or ranges. This ensures that only authorized users can edit sensitive information while allowing others to view it.

Learn how to protect your data in Google Sheets by locking specific sheets or ranges. This ensures that only authorized users can edit sensitive information while allowing others to view it.

  1. Open Google Sheets and click on the sheet tab at the bottom that you want to lock.

  2. Click on the small downward-facing arrow on the sheet tab and select "Protect sheet" from the dropdown menu.

  3. In the right-hand "Protected sheets and ranges" sidebar, click "Set permissions."

  4. Choose whether you want to restrict editing to specific users or only allow certain people to make changes.

  5. Click "Done" to apply the lock, preventing unauthorized edits to the sheet.

  6. You can edit or remove the restrictions anytime by revisiting the "Protected sheets and ranges" settings.

Ready to transform how you create content?

Ready to transform how you create content?

Ready to transform how you create content?

© Copyright 2025, Layerpath Inc.

© Copyright 2025, Layerpath Inc.

© Copyright 2025, Layerpath Inc.