If you ’re using Google Sheets to work on a collaborative project then you ’ll understand the frustration of take your study accidentally blue-pencil or modify by another user .
as luck would have it , Google Sheets allows you to lock mobile phone , which means editors can still access and cut your spreadsheet but wo n’t be able-bodied to delete any locked mobile phone .
Keep reading to learn how to lock cells in Google Sheets and prevent editor program from being able to change your data .
What you’ll need:
The short version:
Step 1.
Open your document in Google Sheets
you may either set out a newfangled vacuous document or open up an live written document .
Step 2.
Select the cell or cells you want to lock, then right-click
To select multiple cell , simply urge on and nurse the leftover mouse button against all the desired cells . Then right - click over the take cellphone or cells .
Step 3.
Hover over View more cell actions
Once you right - chink , you ’ll see a menu . You may need to scroll down to find the thought more cell actions option .
Step 4.
Click Protect range
After hover over aspect more prison cell actions , tap Protect range . A side panel will then appear .
Step 5.
Select Add a sheet or range
The old step will bring up this side board .
Step 6.
Name or describe your cell, then select Set permissions
Naming the cell is optional but utilitarian if you want to engage multiple electric cell for unlike users . Otherwise you could skip this and go straight for Set permit .
Step 7.
Confirm your permission preference
Here you may choose who can cut the cell . you may set it as ‘ only you ’ or , by choose Custom , you may choose which users are able-bodied to delete the cellular telephone .
Step 8.
Select Done
Your choices will be economize .
Troubleshooting
To cut existing locked cell permissions , quality data point on the top menu panel . Then Protect Sheets and range , which will bring up the side instrument panel that list all the locked cells . Choose which one you would care to edit and pick out Change permissions .
Unfortunately , you may only lock cell by using a computer .
