Tip! This guide will show you how to lock a row on Google Sheets to prevent others from making changes, or send a warning when changes are made.
Navigate to Google Sheets <https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0>
Right click on the row you want to lock
Click "Show more row actions"
Click "Protect range"
Optionally, you can give your range a title.
For example, this locked row is called "Lead List"
Change your range by clicking the four square button on the right side of the bar
Once your range is selected, click "Ok"
Optionally, change the sheet
Click "Set permissions"
Select if you would like to show a warning when editing the range, or restrict who can edit the range
You can create custom permissions by clicking "Custom"
To add the custom permissions, click the "Enter names or email addresses" field.
Type in the email address of who you are sharing the permissions with.
When finished, click "Done"
Documents you might like
0 Selected
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key