Skip to content

§ 3.8Using SuperSheets

Validation & Frozen Panes

Data Validation Indicators#

SuperSheets validates cell content based on the column type and surfaces errors with four distinct visual indicators. Hover over a validation indicator in a cell to see a tooltip explaining the specific issue.

  • ErrorValue is completely invalid for the column type (e.g. text in a number column).
  • WarningValue is valid but outside the expected range or format (e.g. percentage > 100).
  • InfoA soft hint — e.g. a date is in the far future, or a currency has no symbol.
  • ValidValue passes all validation rules for this column type.

Frozen Panes & Sticky Headers#

Column headers are always frozen — they stay visible as you scroll down through hundreds of rows. The row numbers on the left are also sticky.

If your sheet has many columns, the first column can be frozen so it remains visible as you scroll right. Look for the freeze toggle in the column dropdown menu (right-click the first column header).

Undo & Redo#

Every data change in SuperSheets is tracked in an in-memory history stack, giving you a full undo/redo chain for the current session.

ShortcutAction
Ctrl / ⌘ + ZUndo the last action
Ctrl / ⌘ + Shift + ZRedo (re-apply undone action)
Ctrl / ⌘ + YRedo (alternate shortcut)