If you are interested in learning how to lock cells in google sheets, read on. Also, get to know the easy ways to. By freezing the top row, the column titles will scroll with you! Pretty much anything Microsoft Excel can do, Google Sheets can do online with other people and with some streamlined features from the Google Suite. However, if you need to let someone else edit the cells, just go to custom option. This is exactly the opposite of what we explained in the previous part. See the example below for the menu option. In the dialog box which opens up on the right, you can give your Named Range a nickname keep it short so you can use it in a formula.
Also see our article Sheets supports up to 20k rows and can be used by a ton of different users at once. How to Protect a Range in Google Sheets The steps in this article were performed in the desktop version of the Google Chrome Web browser. We hope this article helped you in some way or another. You can use this option to make only the experts edit the cells with responsibility. So, single deletion of data on a cell can change the whole output of the spreadsheet. The data on the spreadsheets you are using can be really sensitive. They will receive an error message if they try to modify the protected cells or ranges.
A user determined to change data can easily crack the password protection. Do you restrict users from entering the spreadsheet at all, or are you implementing cell-by-cell or sheet-by-sheet controls? To add editors, simply enter their email id and click on Done. Instead of having to type or paste in the whole list for every range, you can copy the same permissions from another protected range already included in the spreadsheet by selecting the Copy permissions option. In this case, since you want to protect a range of cells, select Range. In data validation, if you want, you can select a single column range like A2:A100.
Here the data validation setting is same except the custom formula. For protected ranges, team members will see them marked out with a checkered background as you can see in the screen below: If the background pattern makes it difficult to read spreadsheet content, you can hide protected ranges by pointing your mouse to the View menu and unchecking Protected Ranges. Protecting Cells in Google Sheets One of the best features of Google Sheets and all the other Google apps is the ability for anyone with edit access to collaborate on documents in the cloud. This can be a better alternative not only if you want to restrict editing on an entire sheet, but if you want to restrict the majority of the cells on a sheet. This will instantly freeze all the rows above the gray line as shown below : 2 Freeze Rows in Google Sheets Using the View Options While the mouse trick shown above is super handy, there is another way to freeze rows in Google Sheets. To put a warning on editing cells, follow the same steps covered above to get started.
Once you have protected your cells, any collaborators on the document will see the cell data but will be unable to edit the cell. If not, you can even protect the entire spreadsheet as well. However, many forget that Google has its own online alternative called Google Sheets. You can also lock cell ranges in Sheets spreadsheets with scripts. Click Add another range to select multiple cell ranges. Such an approach would let other users just see the spreadsheet.
However, even if you see the warning, you can edit the cells. In the sidebar, you can set a name easily, and it will give you an idea about the cells. With this approach, you can protect the entire spreadsheet and leave some cells to be edited. So, anytime you make use of Google Sheets, especially when you are using it alongside collaborators, do not forget the call lock feature. Conclusion As you may know, spreadsheets play a vital part in your official work on a daily basis. It is very apt for analysis, assignments, models and many more.
You can protect the entire sheet and then allow access to specific cells. In that case, people would still need edit permission, but it would be kind of a pain to select all the cells on the sheet except for the few on which you want to allow editing. Some of the data changes are accidental, and some of them are on purpose. Begin by opening the cell sheet everybody is working on. Last updated on 7 Sep, 2018. Therefore, it is understandable the importance of protecting the cells. Team members may have edit access for the remaining cells but not for the protected one.
To protect all the cells within a spreadsheet, click the downward-pointing arrow on the sheet tab next to the name of the sheet at the bottom left of the spreadsheet and select Protect sheet. Click the Delete range or sheet protection option, and then press the Remove button. You can control an entire range of cells with one single tick box. I could now put the checkboxes on another sheet and hide the sheet!! Freezing columns is super easy. These permissions are granted via name or email address.
For example, if I check the tick box in cell E3, the cells in the range A3:D3 will be locked. . There is no need to navigate all the way to the top to remind yourself what you are looking at, not to mention the fact that this will make your spreadsheet look much more professional. Note that there are two thick gray lines in that box on the right and to the left. This may not be something you want.
Next, click the trash bin, located next to the description of the rule. Lock Data Cells To prevent data mess-ups, a top member can help safeguard data cells. Google Docs recently solved this problem by introducing restrictions on editing cells and also another layer of protection where you can also protect entire sheets. The cell B2 is locked using the tick box in E2. Also, you can let them edit only the specific cells.