Cells in Google Sheets Spreadsheets are fragile documents; It’s easy to accidentally replace a cell that “breaks” a calculation, ruins the formatting, or causes the overall document to be incorrect.
Therefore, like any spreadsheet, it is important to know how to lock cells in Google Sheets. Fortunately, Google Sheets allows you to lock cells, Which saves them from changes or unlocks them for editing with just a few clicks.
What does it mean to lock cells in Google Sheets?
Before we get to the real information about cell locking in Google Sheets, it takes us a moment to understand what options Google Sheets have at your disposal.
When you lock cells in Google Docs, you have two options:
Show a warning
If someone (including myself) tries to edit a protected cell in this way, Google Sheets will display a warning, but you can allow the cell to be changed when the user remains. It is a type of safety valve that prevents accidental changes but does not prevent anyone from making changes when necessary.
Related: Remove Duplicates in Google Sheets Click Here
If a cell is protected in this way, only those who have permission to edit the cell can make changes. It can only be you and you alone, or your list of permissions A number of others included in.
How to lock cells in Google Sheets
You can lock single or multiple cells in Google Sheets. That includes entire rows and columns as well. That is how.
- Select the cell or range of cells you want to lock.
- Right-click on the selected cells and then choose Protect Range from the menu.
3 In the Protected Sheets and Ranges sidebar on the right side of the browser, give the selection a name if desired (but do not press Enter). You don’t need to give it a name, but it can make it easier to find a protected cellset later.
- Click Set Permissions.
- In the Range Editing Permissions dialog box, choose whether you want to display only one warning (allowing cells to be edited) or restrict who can edit it. If you choose to Restrict who can edit this range, click on the drop-down menu and choose Just you or Custom, and add the email address of each person you want to allow editing. When you’re ready, click Done
Note: If you have already protected at least one set of cells in this document, you can also choose Copy permission from another category and then select that set of cells from the list that appears.
This is an easy way to apply the same set of editors that can edit this new selection.
How to unlock cells in Google Sheets
You may eventually want to stop protecting certain cells in a spreadsheet. You can also do it with just a few clicks.
- If the Protected Sheets and Ranges sidebar is not visible in your spreadsheet, click Data in the menu bar at the top of the screen and select Protected Sheets and Ranges.
- In the sidebar, click the cell or range of cells you want to unlock.
- Click the trash can icon to the right of the cell description. In the popping dialogue, click Delete. This will only remove protection from the cells, not the data included in the cells.
The UNIQUE function in Google Sheets returns unique rows from the provided source range, leaving duplicates. The SOLE function returns the rows in the order they first appear in the source range. With this method, you can view and compare both data sets before removing the original duplicate.