Step-by-step guidance for using SingleSheet. For a full list of capabilities, see the Features page.
Go to singlesheet.app in any modern browser. No account, no download required. The spreadsheet loads immediately with a blank grid.
Click any cell in the grid to select it, then start typing. Press Enter to confirm and move to the next row, or Tab to confirm and move right. You can also type directly into the formula bar at the top of the screen.
Click the cell to select it, then press F2 to open edit mode without overwriting the existing value. You can also double-click the cell. To overwrite, just start typing — the existing value is replaced immediately.
Click a cell and type = to begin a formula. SingleSheet recognizes =SUM(), =AVERAGE(), =MAX(), =MIN(), =COUNT(), and =IF(). Press Enter to evaluate. If the formula cannot be evaluated, the cell will show an error like #ERR!.
=SUM(A1:A10) adds cells A1 through A10.
Tip: select the destination cell, type =SUM(, then click and drag across the range you want to sum — SingleSheet inserts the range reference automatically.
=AVERAGE(B1:B12) divides the total of B1:B12 by 12. Empty cells count toward the divisor. To average only non-empty cells, use =SUM(B1:B12)/COUNT(B1:B12).
Syntax: =IF(condition, value_if_true, value_if_false)
=IF(A1>100,"Over budget","On track")=IF(B5=0,0,B4/B5) — avoids divide-by-zero=IF(C1="Yes",1,0) — text comparisonConditions support: > < >= <= = <>
Use SheetName!CellId syntax:
=Summary!B5 — value of B5 on the "Summary" sheet='Q1 Report'!C3 — sheet name with spaces requires single quotes=SUM(Sales!A1:Sales!A30) — range from another sheetSheet names are case-insensitive in formulas.
#CIRC! appears when a formula refers to itself, either directly or through a chain of references. For example, if A1 contains =A1+1, that is a circular reference. Fix it by changing one of the formulas to break the cycle.
#ERR! appears when SingleSheet cannot evaluate the formula. Common causes:
#DIV/0! appears when a formula divides by zero. For example, =A1/B1 when B1 is empty or zero. Guard against it with IF: =IF(B1=0,0,A1/B1).
#VALUE! appears when a formula produces a result that is not a finite number (for example, the result is Infinity or NaN). Check the inputs to the formula for edge cases.
Click the + button in the sheet tab bar at the bottom of the screen. A new sheet is created with a default name like Sheet2. Double-click the tab to rename it immediately.
Double-click the sheet tab. Type the new name and press Enter. Sheet names must be unique (case-insensitive).
Click the small × on the right side of a sheet tab. The last remaining sheet cannot be deleted.
Click any sheet tab at the bottom of the screen. The grid updates immediately.
Select the cell or range, then click the B or I button in the toolbar, or press Ctrl+B / Ctrl+I (Cmd on Mac). Click again to remove the formatting. Formatting applies to the entire cell.
Select the cells to format, then choose Currency from the number format dropdown in the toolbar. Values display with a currency symbol and two decimal places. The underlying stored number is not changed.
Select the cells and choose Percent from the dropdown. The displayed value is the stored number multiplied by 100, with two decimal places — so 0.75 displays as 75.00%.
Select the formatted cells and choose General from the dropdown. This resets the display to the raw number value.
Click the first cell, then hold Shift and click the last cell. Or click and drag across the cells you want. The status bar at the bottom shows statistics for the selected range.
Hold Shift and press an arrow key to extend the selection one cell at a time in that direction.
| Shortcut | Action |
|---|---|
| Ctrl+B | Toggle bold |
| Ctrl+I | Toggle italic |
| Ctrl+Z | Undo |
| Ctrl+Y / Ctrl+Shift+Z | Redo |
| Ctrl+C | Copy selection |
| Ctrl+V | Paste |
| Delete / Backspace | Clear cell contents |
| Arrow keys | Move selected cell |
| Shift+Arrow | Extend selection |
| Tab | Confirm and move right |
| Enter | Confirm and move down |
| Escape | Cancel editing |
| F2 | Edit cell without overwriting |
On Mac, substitute Cmd for Ctrl in all shortcuts.
Your data is saved to your browser's local storage under the key singlesheet. It never leaves your device — no data is sent to any server. Different browsers on the same device have separate local storage; your Chrome data won't appear in Firefox.
SingleSheet does not currently have a built-in export button. To export, select all cells, copy with Ctrl+C, and paste into another spreadsheet application such as Google Sheets or Excel.
Open your browser's developer tools (F12), go to Application → Local Storage, find the entry for singlesheet.app, and delete the singlesheet key. Refreshing the page starts with a blank spreadsheet.