How to lock cells and sheets in Google Sheets | Scribe

    How to lock cells and sheets in Google Sheets

    information ordinal icon
    This Scribe shows you how to lock certain ranges (groups of cells) or entire sheets in Google Sheets
    1
    Navigate to your spreadsheet
    2
    Right click on a cell in the range you want to lock
    3
    Hover your mouse over "View more cell actions" at the bottom of the menu and click "Protect range"
    4
    A side panel will appear. Click "Add a sheet or range"
    5
    If you just want to lock a specific group of cells, select "Range" and input the cell range in the range field
    6
    If you want to protect a whole sheet, select "Sheet"
    7
    Select the sheet you want to lock by opening up the dropdown
    8
    Click "Set permissions"
    9
    You can set it so only you can edit the restricted range/sheet, or you can set a custom permission.
    10
    To finalize, click "Done"