The above steps would protect the sheet so that no one other than you can edit it. You can change sheet name here in case you want to protect some other sheet In the Sheet option, you would already see the selected sheet name.In the ‘Protected Sheets and ranges’ pane that opens up, enter a description for the sheet you’re protecting.Right-click on the sheet tab that you want to protect.Just like you can protect a cell or a range of cells, you can also protect an entire sheet.Īnd 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.Īlso, when protecting a sheet, you can choose to keep some of the sheets unlocked.īelow are the steps to protect an entire sheet in Google Sheets: This way, they can’t mess with other people’s data (intentionally or by accident) Protect Entire Sheets in Google Sheets You can set the permission in such a way that each person get editable access to only those cells that they have to fill. Imagine you work with 10 people who need to enter data in the same Google Sheets document. I find this ability to allow selective access to cells/ranges while locking all the other cells really useful. And in case you want to revoke permission of someone who already has it, you can do that as well. Note that you can add more people to this list if you want to give edit permission to more people later. The above steps would lock the selected cell for everyone, except for those people whose email you have entered in Step 8 In the ‘Add editors:’ option, enter the email of the people who you want to allow to edit the locked cell/range/sheet.In the ‘Range editing permissions’, in the ‘Restrict who can edit this range’ options, select ‘Custom’.Suppose, you want to lock cell E2, but this time, you also want to give your colleague the ability to edit it if needed.īelow are the steps to lock a cell (or range of cells) and give edit permission to someone (can be multiple people): In the awesome world of Google Sheets, this can be done easily. Now, 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. Lock Cells And Give Edit Permission to Selected People Just select a range of cells, lock it, and then do the same for the other range of cells. Note: You can not lock a non-contiguous range of cells in one go, but you can do that one by one. All you need to do is selected the range that you wan to lock and then follow all the steps from Step 2 onwards. 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. In case anyone other than you try to change the cell, they will get a dialog box as shown below: The above steps would lock the cell (E2) so that only you can change it. In the ‘Range editing permissions’, make sure ‘Only you’ is selected in the ‘Restrict who can edit this range’ option.You can change this here if you want to lock any other cell In the Range option, you would already see the selected cell’s reference.Enter a description for the cell you’re locking.In the ‘Protected Sheets and ranges’ pane that opens up on the right, click on ‘Add a sheet or range’.Right-click on the cell that you want to lock.So, I can lock the cell.īelow are the steps to lock a cell in Google Sheets (so that no one can change it except you): In 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.įor example, suppose I have the data as shown below and I don’t want anyone to mess with the value in cell E2. Show Warning But Allow Editing of Locked Cells.Lock Cells And Give Edit Permission to Selected People.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.
#How to lock certain cells in excel mac how to
In this tutorial, I will show you how to lock cells in Google Sheets. 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. There is a high chance someone may accidentally edit to delete some cell’s content. This is especially useful when you have multiple people entering data or changing formulas on the same sheet. Google Sheets allows you to easily lock cells so that you can prevent other people from making changes to these specific cells. You might want to share only one sheet with your coworkers which is also possible. 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). One of the best things about Google Sheets is that allows you to collaborate with other people easily.
0 kommentar(er)
