cat / 012
clone

a spreadsheet for the terminal: lotus 1-2-3 looks, google sheets keys and formulas, one go binary

cat/module-path
012 / docs / sheets / notes-protection.md
notes-protection.md 1.9K rendered
1---2title: "Notes and protection"3sidebar_position: 94---56# Notes and protection78## Notes910Insert > Note (Shift+F2, or Insert note on the right-click menu) adds a11note to the active cell, as Sheets' notes: plain text typed on the context12line, where Alt+Enter or Shift+Enter starts a new line (shown as ↵), and13an empty note deletes it. A cell with a note shows ▝ in its top-right14corner; while it is the active cell, the context line shows the note, and15while the mouse is over it, a box beside it does. Delete notes (on the16right-click menu) removes the notes of the selection.1718A note belongs to its cell: clearing the contents (Del) keeps it, it moves19with the cell when rows or columns are inserted, deleted or sorted, and a20copy or a cut takes it along, as in Sheets. Ctrl+Enter fills the entry21into the selection and leaves each cell's note alone. Every change to a22note is an undo step. Pivot table results can't take notes.2324## Protected sheets and ranges2526Data > Protect sheets and ranges works as Sheets' protection with "Show a27warning when editing this range": it locks nothing, but an edit that28touches a protected range, or anything on a protected sheet, asks first on29the context line: Enter edits anyway, Esc cancels. The picker lists the30sheet's protections; its first rows protect the selection or the whole31sheet, with an optional description, Enter on a protection selects its32range, and Ctrl+D removes it. Protect range and Remove protection on the33right-click menu and in the palette do the same for the selection.3435What asks: typing into a cell, commands that change cells (clear, paste,36fill, formats, sort, delete rows), pasting text from the terminal and the37fill handle. Inserting rows or columns moves a protected range without38asking, unless the whole sheet is protected. Macros that run don't ask, as39Sheets' scripts don't. Protected ranges follow inserted and deleted rows40and columns, save with the sheet, and adding or removing one is an undo41step.