Skip to main content

How to lock cells in Google Sheets

how to lock cells in google sheets locked warning imac
Image used with permission by copyright holder

To prevent cells from being edited, you can lock them in Google Sheets. This is especially convenient if you’re working on a spreadsheet with others. You may have formulas or functions that you want to make sure no one can change.

What’s nice about the ability to lock cells in Google Sheets is that you have flexibility. You can lock a single cell, a range, column, row, or the entire sheet. In addition, you can choose the permissions for the locked cells. This lets you allow certain people the ability to change them.

Here’s how to lock cells in Google Sheets, adjust the permissions, and unlock the cells for editing later.

Recommended Videos

Difficulty

Moderate

Duration

15 minutes

What You Need

  • PC, laptop, tablet, or smartphone with Google Sheets access.

Lock specific cells in Google Sheets

Log in to Google Sheets and open the spreadsheet you want to lock cells in. Note: You can also open the spreadsheet from your Google Drive.

Step 1: Select the cells you want to lock. Again, this can be an individual cell, cell range, row, or column.

Step 2: Click Data > Protect sheets and ranges from the menu or right-click the selection, move to View more cell actions, and pick Protect range in the pop-out menu.

Protect sheets and ranges in the Data menu.
Image used with permission by copyright holder

Step 3: You’ll then see the Protected Sheets and Ranges sidebar open. Confirm that the Range tab is selected. Your chosen cells appear in the range box that you can edit if needed.

Step 4: Optionally, add a description in the Enter a description box.

Step 5: Click Set permissions.

Protected Sheets and Ranges sidebar for a range.
Image used with permission by copyright holder

Step 6: When the Range Editing Permissions box appears, you’ll decide who can edit the locked cells or provide a warning if someone tries to edit them.

Option 1: To only display a warning, mark the first option for Show a warning when editing this range.

Option 2: To restrict the editing to certain users, mark the second option for Restrict who can edit this range. Click the drop-down box and pick Only you, Custom, or Copy permissions from another range.

If you select the Custom option, you’ll see a list of those you’re sharing the sheet with at the bottom. Check the boxes to the right of those you want to allow editing permissions. Optionally, you can add more editors at the bottom.

Permissions for protecting locked cells in Google Sheets.
Image used with permission by copyright holder

Step 7: Click Done when you finish.

Note that even sorting data in Sheets isn't possible when the cells are locked.

Lock a sheet in Google Sheets

If you want to lock the cells in an entire sheet or want to lock all but certain cells in a sheet, this is also an option.

Step 1: Select any cell and go to Data > Protect sheets and ranges in the menu or right-click the sheet, move to View more cell actions, and pick Protect range.

Protect range in the More cell actions menu.
Image used with permission by copyright holder

Step 2: When the Protected Sheets and Ranges sidebar opens, click the Sheet tab.

Step 3: Pick the name of the sheet you want to lock from the drop-down list.

Step 4: If you want to lock all but specific cells, check the box for Except certain cells. Add the cell, range, column, or row in the corresponding box. To include more, click Add another range and do the same.

Step 5: Optionally add a description in the Enter a description box.

Step 6: Click Set permissions.

Protected Sheets and Ranges sidebar for a sheet.
Image used with permission by copyright holder

Step 7: When the Range Editing Permissions box appears, choose Option 1 or Option 2 as described above and complete the details.

Permissions for protecting locked cells in Google Sheets.
Image used with permission by copyright holder

Step 8: Click Done.

Change permissions for locked cells

There may come a time when you want to adjust the permissions you set for locked cells. You may want to add another editor or remove one.

Step 1: Go to Data > Protect sheets and ranges in the menu or right-click, move to View more cell actions, and pick Protect range.

Step 2: In the Protected Sheets and Ranges sidebar, you’ll see a list of cells or the sheet you’ve locked. Select the one you want to edit.

Protected Sheets and Ranges sidebar with protected ranges.
Image used with permission by copyright holder

Step 3: Click Change permissions.

Change permissions option for a protected range.
Image used with permission by copyright holder

Step 4: Make your changes in the pop-up window and click Done when you finish.

Unlock cells in Google Sheets

If you want to remove the lock you’ve placed on cells or on a sheet, you can do this easily.

Step 1: Go to Data > Protect sheets and ranges in the menu or right-click, move to View more cell actions, and pick Protect range.

Step 2: In the Protected Sheets and Ranges sidebar, you’ll see a list of cells or the sheet you’ve locked. Select the one you want to unlock.

Protected Sheets and Ranges sidebar with protected sheets.
Image used with permission by copyright holder

Step 3: Click the trash can icon to the right of the description.

Trash can icon to remove protection from a sheet.
Image used with permission by copyright holder

Step 4: Confirm that you want to remove the protection by clicking Remove in the pop-up window.

Confirm screen for removing protection in Google Sheets.
Image used with permission by copyright holder

Protecting data and formulas by locking cells in Google Sheets only takes a few minutes and is worth the time to keep your data safe.

For more, take a look at how to make a graph in Google Sheets for a visual display of your data.

Sandy Writtenhouse
Sandy has been writing about technology since 2012. Her work has appeared on How-To Geek, Lifewire, MakeUseOf, iDownloadBlog…
Google gives Gemini a boost in Sheets and a cool trick in NotebookLM
Working with Google Gemini in Sheets.

Google is expanding Gemini integration within its Workspace suite and has announced a couple of new tricks for its underrated NotebookLM tool. The first in line is the ability to create structured tables in Google Sheets with text prompts.

So far, all tables created by the AI were served in plain text with only bold highlights for the headers. Needless to say, they looked drab and boring, lacking any character at all. There was no text formatting or stylistic edits to the cell contents.

Read more
Google Sheets vs. Microsoft Excel: Which is better?
Microsoft's PowerPoint on the Vision Pro.

Workplace visualization tools make the world go round, and will definitely liven up your before-lunch presentation. If you’ve got hard numbers to display to the masses, or graph-scribed projections you’re eager to get onscreen, you’ll need a powerful spreadsheet. You can use Google Sheets, or you can use Microsoft Excel -- they're both great ways to get the job done. But which of these two platforms is truly the best option? That depends on a number of things, and we’re not here to dissuade or encourage, but merely to inform.

We actually love Google Sheets and Excel, but for different reasons. One software may not be ideal for A, B, and C, although it may be really good at D, E, and F. Whatever the case may be, we put together this comparison of Google Sheets and Excel, with focus paid to essential categories like application access, data analysis, and charts and graphs. 
The basics
It’s worth stating from the start that both Sheets and Excel are excellent spreadsheet applications. So if you have the opportunity to try them both out, you may have a clear preference from the start. But if you’re doing your research first, just know that you can’t go wrong with either.

Read more
How to convert Excel files to Google Sheets
A MacBook on a table using Google Sheets.

If you use Google Sheets, then you'll know that it is a versatile tool that can pick up and run with any existing spreadsheets from applications like Microsoft Excel. You can even convert existing Excel spreadsheets to Google Sheet documents. Whether you're looking to using Microsoft Excel or want the improved ease of collaboration and sharing that Sheets offers for that particular spreadsheet, here's how to convert Excel files to Google Sheets in just a few steps.

Read more