Using SuperSheetsData entry & column types

Data Entry & Column Types

Every column has a type that controls how data is displayed, validated, and aggregated. Right-click a column header to change its type.

TypeBehaviour
TextFree-form strings. No validation.
NumberIntegers and decimals with optional range/bounds validation.
CurrencyMonetary values with configurable symbol (e.g. $, €, £).
DateDates with format options and future/past validation.
PercentageValues from 0–100 with overflow detection.
StatusDropdown of preset labels: Active, Pending, Paid, and more.

Editing Cells

  • Single-click a cell to select it (highlighted in gold).
  • Double-click, or press Enter / F2, to enter edit mode.
  • For Status columns a dropdown appears automatically when you enter edit mode.
  • Press Enter to confirm and move down, or Tab to confirm and move right.
  • Press Escape to cancel without saving.
  • Start typing on a selected cell — SuperSheets auto-enters edit mode when you press any printable character key.

Keyboard Navigation

KeyAction
↑ ↓ ← →Move selection one cell in any direction
TabMove right (wraps to next row)
Shift + TabMove left (wraps to previous row)
EnterConfirm edit and move down
Ctrl / ⌘ + HomeJump to cell A1
Ctrl / ⌘ + EndJump to last data cell
Tip
The Name Box at the top-left of the editor shows the address of the active cell (e.g. B4). Type a cell address into the Name Box and press Enter to jump directly to that cell.