Using SuperSheetsValidation & frozen panes

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.

Error

Value is completely invalid for the column type (e.g. text in a number column).

Warning

Value is valid but outside the expected range or format (e.g. percentage > 100).

Info

A soft hint — e.g. a date is in the far future, or a currency has no symbol.

Valid

Value 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)
Warning
The undo history is in-memory only and is cleared when you navigate away or refresh the page. Data is auto-saved to localStorage on every change.