SingleSheet evaluates formulas beginning with =. Type a formula into any cell or the formula bar and press Enter to evaluate it.
Adds all numeric values in a range. =SUM(A1:A10) returns the total of cells A1 through A10. Empty cells are treated as zero.
Returns the arithmetic mean of a range. =AVERAGE(B1:B12) divides the sum of B1:B12 by the number of cells in the range. Empty cells count toward the divisor.
=MAX(A1:A10) returns the largest value in the range; =MIN(A1:A10) returns the smallest. Empty cells are excluded from comparison.
=COUNT(A1:A10) counts cells in the range that contain numeric values. Text cells and empty cells are not counted.
=IF(condition, value_if_true, value_if_false)
Example: =IF(A1>100,"Over budget","On track")
Conditions support comparison operators: > < >= <= = <>. IF can be nested: =IF(A1>100,"High",IF(A1>50,"Mid","Low")).
Reference cells on other sheets using SheetName!CellId syntax. Example: =Summary!B5 pulls the value of cell B5 from the sheet named "Summary". For sheet names containing spaces, wrap in single quotes: ='Q1 Data'!A1.
Prefix column letters and/or row numbers with $ to anchor them when pasting. =$A$1 always refers to A1 regardless of where the formula is pasted. =$A1 anchors the column but lets the row shift. =A$1 anchors the row but lets the column shift.
Create, rename, and delete sheets using the tab bar at the bottom of the screen. Each sheet has its own independent grid of 26 columns (A–Z) and 100 rows. All sheets are saved together as a single unit in local storage.
Select one or more cells and press Ctrl+B or Ctrl+I (Cmd on Mac). The Bold and Italic buttons in the toolbar also toggle formatting on the selection. Formatting is independent of cell values — clearing a cell's value does not remove its formatting.
The format dropdown in the toolbar applies a display format to numeric cells:
Ctrl+Z (Cmd+Z) undoes the last change. Ctrl+Y or Ctrl+Shift+Z redoes. The undo history holds up to 100 steps per session.
Select a range and press Ctrl+C to copy, then Ctrl+V to paste at the cursor location. Pasting a formula adjusts relative cell references automatically — just like desktop spreadsheets. Absolute references (using $) are not adjusted.
Press Delete or Backspace on a selected range to clear cell contents. Formatting (bold, italic, number format) is preserved when clearing values.
Arrow keys move the selected cell. Tab moves right; Enter moves down after confirming an edit. Shift+Arrow extends the selection range. F2 opens edit mode without overwriting the current value. Escape cancels an edit.
Drag the border between any column header or row header to resize it. The new size persists in local storage with the rest of the sheet data.
When one or more cells are selected, the status bar at the bottom shows Count, Sum, Average, Min, and Max for the selected range — calculated live as the selection changes.
While editing a formula, pressing an arrow key enters pointing mode — instead of moving the cursor in the text, it moves the cell selection and inserts the selected cell reference into the formula. Shift+arrow extends the reference to a range. Click a cell to point to it with the mouse.
Your spreadsheet is automatically saved to your browser's local storage every time you commit a change. Closing and reopening the tab restores your work exactly as you left it. Data is stored per-browser and per-device — it does not sync across devices or to any server.