LocalSheets v1.2
Single-file, multi-sheet, local-first spreadsheet.
Files
| Ctrl+N | New workbook |
| Ctrl+O | Open |
| Ctrl+S | Save |
| Ctrl+Shift+S | Save As |
| Ctrl+F | Find / Replace |
Navigation & editing
| Click | Select cell |
| Click+drag / Shift+click | Select range |
| Type | Start editing (overwrites) |
| F2 / Enter | Edit current cell |
| Escape | Cancel edit |
| Enter / Tab | Commit, move |
| Arrows | Navigate |
| Shift+Arrows | Extend selection |
| Page Up / Page Down | Page through rows |
| Home / End | Start / end of row |
| Delete / Backspace | Clear cell(s) |
| Ctrl+Z | Undo |
| Ctrl+C, Ctrl+V | Copy / paste (single cell or range) |
| Ctrl+B, Ctrl+I | Bold / italic |
| Ctrl+L / Ctrl+T | Create list / table from current range (auto-detects if you're inside data) |
| Ctrl+G | Jump to address box (type any cell like ZZ500) |
| Ctrl+Home / Ctrl+End | Jump to A1 / last cell with data |
| Ctrl+= / Ctrl+- / Ctrl+0 | Zoom in / out / reset (or use the +/− widget in the status bar) |
| ? | This help |
Sheets
| ＋ button | Add new sheet |
| Right-click tab | Rename, duplicate, delete, reorder |
| Double-click tab | Rename |
| Ctrl+PgDn / Ctrl+PgUp | Next / previous sheet |
Formulas
Start with =. Reference other sheets with SheetName!A1 or 'Sheet Name'!A1.
Functions are case-insensitive.
SUMAVERAGECOUNTCOUNTACOUNTBLANK
MINMAXMEDIANSTDEVVAR
PRODUCTROUNDROUNDUPROUNDDOWNFLOOR
CEILINGINTMODABSSQRT
POWEREXPLNLOGLOG10
PIRANDRANDBETWEENSIGNIF
IFSSWITCHIFERRORIFNAAND
ORNOTXORVLOOKUPHLOOKUP
INDEXMATCHXLOOKUPROWCOLUMN
ROWSCOLUMNSSUMIFCOUNTIFAVERAGEIF
SUMIFSCOUNTIFSAVERAGEIFSCONCATTEXTJOIN
LENUPPERLOWERPROPERTRIM
LEFTRIGHTMIDFINDSEARCH
SUBSTITUTEREPLACEREPTVALUETEXT
EXACTTODAYNOWDATEYEAR
MONTHDAYWEEKDAYEOMONTHEDATE
DATEDIFDAYSNETWORKDAYSPMTFV
PVNPVIRRISNUMBERISTEXT
ISBLANKISERRORISERRISNAISLOGICALN
SPARKLINE
SPARKLINE(range, [type], [color]) - inline chart in a cell.
Types: "line" (default), "bar". Color is a hex string like "#ff0066".
Limits
| Sheets per workbook | 100 |
| Rows per sheet | 10,000 |
| Columns per sheet | 702 (A through ZZ) |
| Undo history | Last 100 actions |