How to lock cells and sheets in Google Sheets | Scribe

    How to lock cells and sheets in Google Sheets

    • |
    • 0 step |
    • 49 seconds
    This Scribe shows you how to lock certain ranges (groups of cells) or entire sheets in Google Sheets
    Navigate to your spreadsheet
    Right click on a cell in the range you want to lock
    Hover your mouse over "View more cell actions" at the bottom of the menu and click "Protect range"
    A side panel will appear. Click "Add a sheet or range"
    If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field
    If you want to protect a whole sheet, select "Sheet"
    Select the sheet you want to lock by opening up the dropdown
    Click "Set permissions"
    You can set it so only you can edit the restricted range/sheet, or you can set a custom permission.
    To finalize, 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