Trusted Reviews is supported by its audience. If you purchase through links on our site, we may earn a commission. Learn more.

How to lock cells in Google Sheets

If you’re using Google Sheets to work on a collaborative project then you’ll understand the frustration of having your work accidentally deleted or altered by another user.

Fortunately, Google Sheets allows you to lock cells, which means editors can still access and edit your spreadsheet but won’t be able to edit any locked cells.

Keep reading to learn how to lock cells in Google Sheets and prevent editors from being able to change your data.

What you’ll need:

  • Google Sheets access and Editing privileges

The short version:

  1. Open your document in Google Sheets
  2. Select the cell or cells you want to lock, then right-click
  3. Hover over View more cell actions
  4. Click Protect range
  5. Select Add a sheet or range
  6. Name or describe your cell then select Set permissions
  7. Confirm your permission preference
  8. Select Done
  1. Step

    Open your document in Google Sheets

    You can either start a new blank document or open an existing document.Google Sheets home page

  2. Step

    Select the cell or cells you want to lock, then right-click

    To select multiple cells, simply press and hold the left mouse button against all the desired cells. Then right-click over the selected cell or cells.Google Sheets right click menu

  3. Step

    Hover over View more cell actions

    Once you right-click, you’ll see a menu. You may need to scroll down to find the View more cell actions option.Google Sheets right click menu with view more cell actions highlighted

  4. Step

    Click Protect range

    After hovering over View more cell actions, click on Protect range. A side panel will then appear.Google Sheets right click menu with Protect range highlighted

  5. Step

    Select Add a sheet or range

    The previous step will bring up this side panel. Google Sheets Protect sheets and ranges side panel open

  6. Step

    Name or describe your cell, then select Set permissions

    Naming the cell is optional but useful if you want to lock multiple cells for different users. Otherwise you can skip this and go straight for Set permissions.Locking a cell on Google Sheets

  7. Step

    Confirm your permission preference

    Here you can choose who can edit the cell. You can set it as ‘only you’ or, by choosing Custom, you can choose which users are able to edit the cell. Edit editing permissions when locking a cell on Google Sheets

  8. Step

    Select Done

    Your choices will be saved.Select Done on Google Sheets


How do I edit locked cell permissions?

To edit existing locked cell permissions, select Data on the top menu panel. Then Protect Sheets and ranges, which will bring up the side panel that lists all the locked cells. Choose which one you would like to edit and select Change permissions.

Can I lock cells on my smartphone?

Unfortunately, you can only lock cells by using a computer.

Why trust our journalism?

Founded in 2003, Trusted Reviews exists to give our readers thorough, unbiased and independent advice on what to buy.

Today, we have millions of users a month from around the world, and assess more than 1,000 products a year.

author icon

Editorial independence

Editorial independence means being able to give an unbiased verdict about a product or company, with the avoidance of conflicts of interest. To ensure this is possible, every member of the editorial staff follows a clear code of conduct.

author icon

Professional conduct

We also expect our journalists to follow clear ethical standards in their work. Our staff members must strive for honesty and accuracy in everything they do. We follow the IPSO Editors’ code of practice to underpin these standards.

Trusted Reviews Logo

Sign up to our newsletter

Get the best of Trusted Reviews delivered right to your inbox.

This is a test error message with some extra words