Lock individual cells, a spreadsheet tab, or an entire spreadsheet to prevent accidental edits to spreadsheet data. Locking spreadsheet data prevents you and other users from making edits.
Locked Cells
When an individual cell is locked, no one can:
- Apply formatting.
- Delete the cell.
- Hide or reveal the row or column containing the cell.
- Freeze or unfreeze the row or column containing the cell.
- Move a row or column containing the cell.
- Use filters with a range containing the cell.
- Sort a range containing the cell.
Locked Tabs
When a tab is locked, no one can:
- Make edits of any kind.
- Add or remove columns or rows.
- Delete the tab.
Locked Embedded Spreadsheets
When an embedded spreadsheet in a Quip document is lost, no one can:
- Make edits of any kind.
- Add or remove columns or rows.
- Delete the embedded spreadsheet.
Locked Spreadsheets
When an entire spreadsheet is locked, no one can:
- Make edits of any kind.
- Add or remove columns or rows.
- Delete any tabs.
- Lock a Spreadsheet Cell
Lock an individual cell or range of cells to prevent edits to only specific spreadsheet data. - Lock a Spreadsheet Tab
Lock one tab in a Quip spreadsheet. - Lock an Embedded Spreadsheet
Lock one spreadsheet embedded in a Quip document. - Lock a Spreadsheet
Lock an entire Quip spreadsheet.