• Home

  • Productivity

  • App tips

App tips

3 min read

How to lock cells in Google Sheets

By Jessica Lau · February 1, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

Truthfully, I can't be trusted with anything nice—and this extends to beautifully formatted, formula-filled Google Sheets spreadsheets. I get all click-happy, and the next thing I know, I'm staring at empty cells where there were once data-filled cells. 

Sure, I could hit Undo, but that's helpful only if I know what errors I need to undo. Or the person sharing their spreadsheet with me could limit my permissions to view or comment only. But that's not practical if we need to collaborate on the file. 

Google rightfully predicted there were more click-happy humans like me, which is why they added the ability for users to protect certain cell ranges and sheets from being tampered with. 

Here's how to lock cells and sheets in Google Sheets. 

Table of contents: 

  • How to lock cells in Google Sheets

  • How to lock an entire worksheet in Google Sheets 

  • How to edit locked cell settings in Google Sheets

  • How to unlock cells in Google Sheets

How to lock cells in Google Sheets

  1. Open a Google Sheets spreadsheet. 

  2. Highlight the cell or cell range you want to protect. 

  3. Click Data > Protect sheets and ranges. Alternatively, right-click your selection, and then click View more cell actions > Protect cell range. 

    Data dropdown in Google Sheets with the protect sheets and ranges option highlighted.

  4. In the Protected sheets & ranges panel that appears, click Set permissions. 

    How to set permissions for locked cells in Google Sheets.

  5. Modify the Range editing permissions in one of the following ways: 

    • Show a warning when editing this range. Other users can still edit the protected range, but they'll get a warning first. This is a good option for dealing with click-happy collaborators.  

      Warning that appears in Google Sheets when a user tries to edit a locked cell.

    • Restrict who can edit this range. You can limit this to Only you. Or you can apply custom settings, giving specific people permission to edit the range. 

      How to set permissions for who can edit locked cells in Google Sheets.
  6. Optionally, in the Protected sheets & ranges panel, enter a description for the locked cells. This is especially practical if you're managing multiple locked sheets and cell ranges. 

  7. Click Done. 

Now, when someone who doesn't have permission to edit a cell range tries to modify it, they'll get a popup notifying them that the cell is protected and to contact the spreadsheet owner to remove the protection, if needed. 

Error message that appears in Google Sheets when someone who doesn't have permission to edit a locked cell tries to modify it.

How to lock an entire worksheet in Google Sheets 

Let's say you have multiple worksheets in your spreadsheet and you want to lock specific worksheets. Here's the easiest way to do it.

  1. Click Data > Protect sheets and ranges. Or right-click any cell, and then click View more cell actions > Protect cell range. 

  2. In the Protected sheets & ranges panel that appears, click Sheet. 

  3. Select the sheet you want to lock. 

  4. Optionally, check Except certain cells to make certain cells within the locked sheet editable. 

    How to lock an entire worksheet in Google Sheets.

  5. Click Set permissions. 

How to edit locked cell settings in Google Sheets

How to edit the cell range of locked cells in Google Sheets

  1. Click Data > Protect sheets and ranges. Or right-click any cell, and then click View more cell actions > Protect cell range. 

  2. Click the locked cell range you want to edit. 

  3. To modify the range of locked cells, manually enter a new range in the Select range field. Or click the Select data range icon, which looks like a grid, highlight the new cell range directly in your worksheet, and then click OK. 

  4. Click Done. 

    Demo of how to select a new data range of locked cells in Google Sheets.

How to change editor permissions of locked cells in Google Sheets 

  1. Click Data > Protect sheets and ranges. Or right-click any cell, and then click View more cell actions > Protect cell range. 

  2. Click the protected sheet or cell range you want to edit. 

  3. Click Change permissions. 

    How to change editor permissions of locked cells in Google Sheets.

  4. Update the Range editing permissions. 

  5. Click Done. 

How to unlock cells in Google Sheets

  1. Click Data > Protect sheets and ranges. Or right-click any cell, and then click View more cell actions > Protect cell range. 

  2. Click the protected sheet or cell range you want to edit. 

  3. Click the Delete range or sheet protection icon, which looks like a garbage can. 

    How to unlock cells in Google Sheets.

Automate Google Sheets 

There are countless ways to accidentally mess up a spreadsheet—the process of entering data doesn't have to be one of those ways. Use Zapier to connect Google Sheets with your go-to apps. This way, you can automatically do things like add new lead data and form submissions to an existing spreadsheet. Learn more about how to automate Google Sheets, or get started with one of these workflow templates.   

Collect new Typeform responses as rows on Google Sheets

Collect new Typeform responses as rows on Google Sheets
  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets

Add Google Sheets rows for new Google Forms responses

Add Google Sheets rows for new Google Forms responses
  • Google Forms logo
  • Google Sheets logo
Google Forms + Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets
  • Facebook Lead Ads logo
  • Google Sheets logo
Facebook Lead Ads + Google Sheets

Add new leads in LinkedIn Ads to Google Sheets rows

Add new leads in LinkedIn Ads to Google Sheets rows
  • LinkedIn Ads logo
  • Google Sheets logo
LinkedIn Ads + Google Sheets

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Related reading: 

  • How to hide rows in Google Sheets

  • How to freeze columns in Google Sheets

  • Google Sheets add-ons to supercharge your work

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'