Using SuperSheetsData entry & column types
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.
| Type | Behaviour |
|---|---|
Text | Free-form strings. No validation. |
Number | Integers and decimals with optional range/bounds validation. |
Currency | Monetary values with configurable symbol (e.g. $, €, £). |
Date | Dates with format options and future/past validation. |
Percentage | Values from 0–100 with overflow detection. |
Status | Dropdown 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
Statuscolumns a dropdown appears automatically when you enter edit mode. - Press
Enterto confirm and move down, orTabto confirm and move right. - Press
Escapeto cancel without saving. - Start typing on a selected cell — SuperSheets auto-enters edit mode when you press any printable character key.
Keyboard Navigation
| Key | Action |
|---|---|
↑ ↓ ← → | Move selection one cell in any direction |
Tab | Move right (wraps to next row) |
Shift + Tab | Move left (wraps to previous row) |
Enter | Confirm edit and move down |
Ctrl / ⌘ + Home | Jump to cell A1 |
Ctrl / ⌘ + End | Jump 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.