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.
1
Navigate to Google Sheets <https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0>
2
Right click on the row you want to lock
3
Click "Show more row actions"
4
Click "Protect range"
5
Optionally, you can give your range a title.
For example, this locked row is called "Lead List"
6
Change your range by clicking the four square button on the right side of the bar
7
Once your range is selected, click "Ok"
8
Optionally, change the sheet
9
Click "Set permissions"
10
Select if you would like to show a warning when editing the range, or restrict who can edit the range
11
You can create custom permissions by clicking "Custom"
12
To add the custom permissions, click the "Enter names or email addresses" field.
13
Type in the email address of who you are sharing the permissions with.
14
When finished, click "Done"
