Knowing how to lock rows in Google Sheets can be helpful.
If youre collaborating on a document, others may need to edit some things on the file.
But, there may be some rows or cells you dont want anyone to touch.
Here are the steps to follow.
Someone may not want to intentionally change something, but accidents do happen.
Heres how it’s possible for you to protect specific information.
tap on theProtect Rangeoption when the side menu appears.
You should now see the Protected sheets and ranges options.
you’re able to manually enter a range of the number of cells you want to protect.
Or, it’s possible for you to opt for cells you want to lock.
Once you choose them, they will be entered into the range automatically.
hit theSet permissionsoption at the bottom right.
That way, they know what info to keep in mind before they change anything.
Choose the Custom option and add those you want to give editing access to.
Youll need to enter their email address.
Locking Columns
Its also possible to lock columns as well.
double-check youve selected the column you want to lock.
Whatever is easier for you.
Both options take you to the same place.
When the list of options appears, choose the one that saysView more column options, followed byProtect Range.
you’re free to also have Google Sheets show a warning before anyone changes anything.
Unlocking
If, after a while, you want to remove the lock, its possible.
To the right, youll see everything youve blocked.
punch the one you want to unlock and punch the trash icon at the top right.
