Cells in the range get a dropdown of allowed values while editing. "Strict" rejects anything not in the list.
Everything you type is stored only in this browser's localStorage — there is no account, no server database, and nothing is ever uploaded. Use Backup to download your workbook as a file (and Restore to load it on another machine).
| Type / F2 / double-click | edit a cell |
| Enter · Tab · arrows | commit + move |
| Shift + arrows / click | extend selection |
| ⌘C · ⌘X · ⌘V | copy / cut / paste (works with Excel & Sheets) |
| ⌘Z · ⌘⇧Z | undo / redo |
| ⌘B · ⌘I · ⌘U | bold / italic / underline |
| Delete | clear cells |
| Right-click | insert / delete rows & columns |
| Drag the fill square | fill down / across (continues numbers, "Item 1", months, weekdays, quarters) |
| Double-click the fill square | fill down to match the neighboring column |
| Σ | AutoSum the numbers above / left of the selection |
| ⌘F | find in sheet (Enter = next, ⇧Enter = previous; ⇄ expands Replace) |
| Right-click | sort, insert/delete rows & columns, notes, data validation |
| Hover a column header | filter dropdown — check/uncheck values to hide rows |
Cond. format adds highlight rules ("> 50,000"), color scales and data bars. Freeze pins row 1 while you scroll. Data validation (right-click) gives cells a dropdown of allowed values. Notes (right-click) show on hover with an orange corner marker. Typed dates like 2024-03-15 become real dates — use DATE, YEAR, EOMONTH, DATEDIF etc.
Import reads CSV and Excel .xlsx files; Export writes CSV or a full .xlsx workbook (formulas included). The workbook dropdown in the top bar manages multiple independent workbooks — all stored in this browser.
While typing a formula you get function autocomplete (↑↓ + Tab to accept), colored highlights on every referenced range, and point mode — click or drag cells in the grid to insert their reference at the caret. Each sheet is 10,000 rows × 52 columns; the practical limit is your browser's ~5 MB localStorage quota.
Reference other sheets like Excel: =Growth!B2 or ='Sales Data'!F2:F25 (quote names with spaces). Renaming a sheet rewrites every formula that points at it.
Named ranges: select any range, type a name (e.g. Revenue) into the Name Box (left of the formula bar) and press Enter. Then use it anywhere: =SUM(Revenue). Typing an existing name in the Name Box jumps to it — try SalesRevenue in the sample workbook.
The Visualizer tab turns your sheets into dashboards — bar, line, area, pie, scatter, KPI, table and pivot visuals with aggregation, group-by, filters, sorting and Top N. Pivots can be materialized as a real sheet with one click. The first row of a sheet is used as column headers. Dashboards are saved in this browser too.
Start with =. Cell refs (A1, $B$2), ranges (A1:C10), operators + - * / ^ & % = <> < > and these functions: