A new feature just released for Google Spreadsheets, 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.

Very powerful! This goes hand in hand with the use of Named Ranges, which I cover in my next video.

Shares

UP NEXT: Using Named Ranges in Google Spreadsheets

Leave a Reply

8 Comments on "Protecting Cell Ranges in Google Spreadsheets"

Notify of
avatar
Sort by:   newest | oldest | most voted
Giordana
Guest
Giordana

Awesome, very informative. I like these newer videos that give us more insight to new features that we usually wouldn’t have stumbled upon. More videos like this, please.

Brett
Guest
Brett

Any idea how I can protect a range from “Anyone with the Link” rather than a specific person. It seems if it’s open to anyone with the link can edit, they can edit the whole sheet, and protection doesn’t work. I don’t want to go through and grant each user permission, as there will be many users.

Cedric
Guest
Cedric

As explained in the video collaborators can go in View and un-check ‘Protected ranges’ to hide the grey dotted background from protected ranges.

Is there a way to make that change permanent? It seems this ‘Protected ranges’ feature is always checked by default when re-opening the spreadsheet.

Thanks!

Jr
Guest
Jr

Hi,
I’ve created some scripts that enter values in some cells. And I’d like to make these cells editable only through this scripts.
I’ve tried this “Protecting Cell Ranges” but it also blocks all the scripts that tries to change any value in those cells, giving the user a “Access denied” msg.
So is there a way to do that? block a cell from a user but allow him to edit it only through scripting???
That would be really helpfull.
thanks in advance.

James
Guest
James

This does not always work. It does not consistently protect cells so be warned.

wpDiscuz

DOWNLOAD

The Ultimate Guide to Google Drive

DOWNLOAD NOW