One of the best things about Google Sheets is that allows you to collaborate with other people easily. Show
When sharing your work with other people, you may also want to lock some cells in Google Sheets (or maybe lock specific rows/column or lock the entire sheet itself). You might want to share only one sheet with your coworkers which is also possible. Google Sheets allows you to easily lock cells so that you can prevent other people from making changes to these specific cells. This is especially useful when you have multiple people entering data or changing formulas on the same sheet. There is a high chance someone may accidentally edit to delete some cell’s content. To prevent this, it’s best to lock the cells only give access to those cells to collaborator where you need them to make the changes. In this tutorial, I will show you how to lock cells in Google Sheets. These could be some specific cells that you want to lock or could be cells in an entire row/column, or even the entire sheet. So let’s get started!
Lock Specific Cells In Google SheetsIn case your Google Sheets document has some cells that should not be changed, you can lock these so that no one is allowed to make any changes to it. For example, suppose I have the data as shown below and I don’t want anyone to mess with the value in cell E2. So, I can lock the cell. Below are the steps to lock a cell in Google Sheets (so that no one can change it except you):
The above steps would lock the cell (E2) so that only you can change it. In case anyone other than you try to change the cell, they will get a dialog box as shown below: While in this example I have just locked one single cell, you can use the same steps to lock a range of cells or even entire rows and columns. All you need to do is selected the range that you wan to lock and then follow all the steps from Step 2 onwards. Note: You can not lock a non-contiguous range of cells in one go, but you can do that one by one. Just select a range of cells, lock it, and then do the same for the other range of cells. Lock Cells And Give Edit Permission to Selected PeopleNow, what if you want to lock a cell in such a way that some selected people other than you can also edit the locked cells. In the awesome world of Google Sheets, this can be done easily. Suppose, you want to lock cell E2, but this time, you also want to give your colleague the ability to edit it if needed. Below are the steps to lock a cell (or range of cells) and give edit permission to someone (can be multiple people):
The above steps would lock the selected cell for everyone, except for those people whose email you have entered in Step 8 Note that you can add more people to this list if you want to give edit permission to more people later. And in case you want to revoke permission of someone who already has it, you can do that as well. I find this ability to allow selective access to cells/ranges while locking all the other cells really useful. Imagine you work with 10 people who need to enter data in the same Google Sheets document. You can set the permission in such a way that each person get editable access to only those cells that they have to fill. This way, they can’t mess with other people’s data (intentionally or by accident) Protect Entire Sheets in Google SheetsJust like you can protect a cell or a range of cells, you can also protect an entire sheet. And again, just like cells and ranges, you can also choose to keep it completely locked for everyone, or give access to some people who can edit it. Also, when protecting a sheet, you can choose to keep some of the sheets unlocked. Below are the steps to protect an entire sheet in Google Sheets:
The above steps would protect the sheet so that no one other than you can edit it. There are some additional things you can do when locking a sheet in Google Sheets:
Show Warning But Allow Editing of Locked CellsAnother option which Google Sheets gives you when locking cells is to not lock these completely, but show a warning message when someone (who has the right to edit the sheet). This wouldn’t restrict the person from editing the cell that you have locked, but they would see a warning (as shown below) when they change the cell content. This could be useful as it would remind the user that these cells are to be handled carefully and they don’t end up changing the cell content or deleting it by mistake. How to Unlock a Locked CellIn case you have locked cells in the sheet and you want to unlock these, follow the below steps:
So these are the ways you can lock cells in Google Sheets, lock entire row or column, and protect sheets. You can also choose to give specific people editable access to the locked cell, which is great when collaborating with multiple people on the same Google Sheets document. I hope you found this Google Sheets tutorial useful! Other Google Sheets tutorials you may like:
How do you show range in Google Sheets?Name a range. Open a spreadsheet in Google Sheets.. Select the cells you want to name.. Click Data. Named ranges. A menu will open on the right. ... . Type the range name you want.. To change the range, click Spreadsheet .. Select a range in the spreadsheet or type the new range into the text box, then click Ok.. Click Done.. What is protect range in Google Sheets?Protected Ranges allows you to select a range of cells and choose which collaborators have permission to edit those cells, and which collaborators should only be able to view those cells.
How do I protect cells in Google Sheets 2022?Steps to lock cells in Google Sheets. Open your sheet and select the cells you want to lock.. Open the Data menu, and select Protected Sheets and Ranges in the dropdown menu.. In the Protected Sheets and Ranges pane, enter a description for the actions you're prohibiting.. Click the Set Permissions button.. |