1 Select the cell or range of cells you want to lock.

           

1. Right-click the selected cells and then choose Protect Range from the menu.

   

2. In the Protected sheets & ranges sidebar on the right side of the browser, give the selection a name if desired (but do not press Enter). You don’t have to give it a name, but it can make it easier to find a protected set of cells later.

   

3. Click the green Set permissions button in the same sidebar.

4. In the Range editing permissions dialog, choose whether you want to only show a warning (which allows the cells to be edited) or to restrict who can edit it. If you choose Restrict who can edit this range, click the drop-down menu and choose Only you or Custom, and add the email address for each person you want to allow editing. When you’re ready, click the green Done button.

   

   If you have already protected at least one set of cells in this document, you can also choose Copy permission from another range, and then select that set of cells from the list that appears. This is an easy way to apply the same set of editors who are allowed to edit this new selection.

How to Unlock Cells in Google Sheets

You might eventually want to stop protecting certain cells in a spreadsheet. You can do that with just a few clicks as well.

1. If the Protected sheets & ranges sidebar is not visible in your spreadsheet, click Data in the menu bar at the top of the screen and choose Protected sheets and ranges.

   

2. In the sidebar, click the cell or range of cells you want to unlock.

3. Click the trash can icon to the right of the cell’s description. In the pop-up dialog, click Remove. This will only remove the protection from the cells, not the data included in the cells.