How to lock a column in Google Sheets | Scribe

    How to lock a column in Google Sheets

    • |
    • 12 steps |
    • 41 seconds
    information ordinal icon

    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.

    1

    Navigate to Google Sheets [https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0](https://docs.google.com/spreadsheets/d/1E0V5OQHw9ALvqfg2pB51ZIyesoSaKBwOwnRVKbi852g/edit#gid=0)

    2

    Right click on the column you want to lock.

    3

    Click "View more cell actions"

    4

    Click "Protect range"

    5

    Click "Add a sheet or range"

    6

    Optionally, you can name your range. For example, Sheet1A! here is titled "Company Name"

    7

    Edit your Range if needed by clicking the button on the right hand side.

    8

    Once done, click "Ok"

    9

    To edit your sheet, click "Sheet"

    10

    Once complete, click "Set permissions"

    11

    Select whether you want to warn a user when editing this range, or restrict who can edit this range.

    12

    Click "Done"