How to lock a column in Google Sheets | Scribe

    How to lock a column in Google Sheets

    • |
    • 0 step |
    • 41 seconds
    Tip! This Scribe will show you how to lock columns 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](https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0)
    Right click on the column you want to lock.
    Click "View more cell actions"
    Click "Protect range"
    Click "Add a sheet or range"
    Optionally, you can name your range. For example, Sheet1A! here is titled "Company Name"
    Edit your Range if needed by clicking the button on the right hand side.
    Once done, click "Ok"
    To edit your sheet, click "Sheet"
    Once complete, click "Set permissions"
    Select whether you want to warn a user when editing this range, or restrict who can edit this range.
    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