How to lock cells and sheets in Google Sheets | Scribe

    How to lock cells and sheets in Google Sheets

    • Google SheetsGoogle 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"