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>

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

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. 

Google

This guide provides step-by-step instructions on how to lock a row on Google Sheets. It explains why someone might want to do this, such as preventing others from making changes or receiving a warning when changes are made. The guide also covers additional features like setting permissions and creating custom permissions.

How to lock a row on Google Sheets