How to lock a row on Google Sheets | Scribe

    How to lock a row on Google Sheets

    • |
    • 0 step |
    • 30 seconds
    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"
    Was this Scribe helpful?
    Save this document for future reference.
    click-target-circles-background
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe