Start here
UnitSheet is a spreadsheet where a value and its unit travel together.
=5m + 3ft → 5.9144m=25mi / 35min → mph=5m + 3s is #UNIT, not a quiet wrong number
Click a cell and type. Enter commits and moves down; Tab moves right.
A number typed over a quantity, money amount, or price keeps that unit
(10m then 5 is 5m). A formula is replaced.
F2 or double-click edits the text as written. The formula bar keeps what you typed.
Keys, editing, and formula pointing are in
(Ctrl+/).
What you can type
Without =, the cell is a value. Formulas start with
= — then slash is division and hyphen is subtraction.
- Number —
10, 3.14
- Quantity —
5m, 3ft, 25mi, 25%,
a compound such as
10L/d or 10m⋅s, or a custom unit
such as 10slab. A product dot may be
., Option-8 •, or Option-Shift-9
· (10ft.lbf displays as
10 ft⋅lbf). Units travel with the
value.
- Money —
$10, 10 USD, 14.32 EUR (display as
$10.00, €14.32)
- Price — money per unit:
$1.25/kg, $3.50/kg
- Date —
2026-09-20, 9/20/2026, or
9-20-2026. Double-click a date cell to pick from a calendar
(keeps ISO or M/D/Y as written)
- Time of day —
23:00
- Instant —
2026-09-20T15:30:00Z (UTC). TODAY() and
NOW() are UTC.
- Text — anything that is not one of the above
TRUE / FALSE
Formulas
Formulas start with =. In a formula, slash is division and hyphen is
subtraction. Cell values omit =.
Cell references
Use A1, a range A1:C3, or $A$1 to lock a
column or row when you fill or copy.
While a formula is open, click, drag, or use arrows to insert refs
(Shift extends a range). While editing a formula, click another sheet tab
to keep the formula open and point there: Sheet2!B12, or
'Q2 Results'!A1 when the name is not a simple identifier.
Quantities
Write a number and a unit: 5m, 30s, 10kg,
10m/s, 10L/d, 10/s, 5/m.
Units autocomplete after a number or ->.
After a number, each row shows the dimension. After ->,
each row shows that value in the unit, right aligned.
Enter takes the highlighted catalog unit, so L/m becomes
L/min. Escape closes the list; then Enter keeps the typed
compound (L/m).
- Same-dimension add converts in place:
=5m + 3ft → 5.9144m.
Mixed dimensions are #UNIT, not a quiet wrong answer:
=5m + 3s.
- Convert with
→ or -> after the expression:
=25mi / 35min → mph,
=5m + 3ft -> in,
=10m*10m → ft^2,
=$3/kg → $/lb.
Arithmetic binds tighter, so the whole sum converts.
# strips a dimensionless unit:
=1 doz -> # is 12.
Convert to unit (toolbar arrow or grid menu) applies this to the selection.
- Inverse units use a leading slash (
10/s, 5/m), not a
negative exponent — 5m-1m is subtraction.
- Temperature: type
degC / degF (they display as
°C / °F; C and F are
coulomb and farad). Option-Shift-8 is the degree sign. Option-0 inserts
º, which is accepted (90º, 10ºC
display as 90 °, 10 °C).
=0 degC -> degF is 32 °F.
A reading is not an interval: =2 °C * 3 is #UNIT.
Use Δ°C / deltaC for differences
(=12 °C - 10 °C is 2 Δ°C).
- Resistance uses
ohm when Ω is awkward to type
(10ohm, 2 kOhm, 1 ohm.m display as
Ω / kΩ / Ω⋅m). Type
ohm for Ω and Ω⋅m; kOhm /
MOhm for kilo- and megaohm.
After a quantity, ^ raises to a power — it is not “type a superscript
in the unit.” Prefer m2 / m/s2 (or real superscripts)
when the unit itself is squared. The unit must follow the caret, not a closing
parenthesis: =10^8 m, not (10^8) m.
Without =, leftover ^ is #SYNTAX
(same as 10^2).
| Type |
Means |
5 m2 or 5 m² |
5 square meters → 5m² |
5 m^2 |
5 meters squared → 25m² |
10 m/s2 or 10 m/s² |
acceleration → 10m/s² |
10 m/s^2 |
(10 m/s)^2 → 100J/kg |
=10^8 m |
10⁸ meters → 100000000m |
=10^8 m^2 |
10⁸ square meters (caret on the unit after the power) |
Money and price
Money is an amount and a currency: $12.50 or 12.50 USD.
$ is USD; other currencies use an ISO code (12.50 EUR)
or their symbol (€12.50).
A price is money per unit: $3.50/kg or 3.50 USD/kg.
After money, / plus a unit is a price, not an inverse-unit quantity.
- Same-currency add and subtract:
=$10 + $2.50 → $12.50,
=$3/kg + $1/kg → $4.00/kg
(price units convert like quantities).
=SUM($3/kg, $1/kg) is the same.
Mixed currencies are #TYPE (no FX yet).
Money or price mixed with a bare number in + / - is also
#TYPE.
- Quantity × price is money when dimensions cancel (units convert first):
=40 kg * $1.25/kg → $50.00,
=40 g * $1.25/kg → $0.05.
Leftover dimension is a price: =200kg/m³ * $3/kg →
$600.00/m³.
Convert a price with ->: =$3/kg -> $/lb
(USD/lb or just lb also work).
Money / quantity is a price: =$50 / 10 kg → $5.00/kg.
Dates, times, and instants
In a cell, 9/20/2026 and 9-20-2026 parse as dates.
In a formula those characters are division and subtraction — use ISO
2026-09-20, =DATE(2026, 9, 20),
=DATEVALUE("9/20/2026"), or
=DATEVALUE("9-20-2026").
- Time of day is a clock, not a duration:
15:30, 15:30:00, optional fractional seconds.
Adding a Time quantity wraps at 24h:
=23:00 + 2 h → 01:00.
- Instant is UTC:
2026-09-20T15:30:00Z
(a space instead of T is fine).
A numeric offset is converted to UTC and dropped; named zones are not accepted.
Date + time of day is that civil datetime as a UTC instant:
=2026-09-20 + 15:30.
- Intervals are Time quantities (
10 d, 10 min), not a
separate duration type.
Date ± an interval is a date only when the interval is a whole number of days
(=2026-09-20 + 10 d → 2026-09-30;
24 h counts as one day;
=2026-09-20 + 10 min is #TYPE).
Instant ± any Time quantity:
=2026-09-20T15:30:00Z + 10 min is a later UTC instant.
Same-kind subtract yields a Time quantity:
=2026-09-20 - 2026-09-10 → 10 d.
TODAY() is the UTC date;
NOW() is the UTC instant.
Compare only within one kind (date with date, time with time, instant with instant).
Operators
- Arithmetic:
+, -, *, /.
Same-dimension add/subtract convert automatically; multiply and divide form new
dimensions (e.g. =25mi / 35min).
Concatenate with &.
- Comparisons:
=, <>, <,
>,
<=, >=.
Quantities need the same dimension; money and prices need the same currency
(price units convert);
dates, times, and instants compare only within one kind.
=10kg > 10lb is TRUE.
- Precedence (tightest first):
^, then * / /,
then + / - / &, then →,
then comparisons.
^ is right-associative (2^3^2 is
2^(3^2)).
Functions
Functions use parentheses: =SUM(1, 2, 3),
=AVERAGE(10m, 5ft), =SIN(90°).
=LET(x, A1*2, x+1) names x for the rest of that formula.
A name starts with a letter or _ and is not a cell address.
Names are case-insensitive.
Angles in trig functions convert to radians (=SIN(90°) is 1;
a bare number is already radians).
Names autocomplete after = (names only).
After (, the signature stays under the cell or formula bar while the
caret is inside the call.
Browse the catalog from
.
Loan and investment math takes a per-period rate.
=PMT(5%/12, 30*12, $200000) is the monthly payment
(negative money). PV, FV, and NPER are that same annuity.
NPV discounts the first cash flow by one period;
IRR treats the first value as today.
A blank cash flow is zero for that period.
Errors
#UNIT — mixed dimensions, or convert to the wrong dimension
(=5m + 3s).
lists every #UNIT in the workbook.#TYPE — mixed kinds (money + a bare number, date + 10 min)#SYNTAX — leftover text, unknown unit, or ^ without
=#REF — a name that is not a cell, a deleted sheet, or a
reference shifted off the grid#NAME — unknown function, or a LET name that is not a
valid identifier#DIV/0 — division by zero#CIRC_REF — a formula that refers to itself (circular refs do not
iterate)
Sheet
Fill
Fill down/right (Ctrl+D /
Ctrl+R) or drag the fill handle to copy a selection.
Numbers, quantities, money, dates, times, and instants continue as a series from
the handle. Formulas shift their relative refs, as in copy.
Copy and paste
Pasting one copied cell fills every cell in the selection.
Relative references shift for each cell; $ holds a column or row.
Cut still moves the source once, at the top-left of the selection.
Drag the border of a selected cell or range to move those cells.
Formulas update as they do for Cut, and merged cells move with the selection.
A drop that would split a merge is refused. Escape cancels the drag.
Paste values
Edit → Paste values (Ctrl+Shift+V) writes
computed values, not formulas; destination format stays.
Rows and columns
Selection stops at the sheet edge; Insert → Row below / Column right add space.
Right-click the grid (or Shift+F10 / the Menu key) for Cut, Convert to unit,
Insert row above / column left (as many as the selection spans), Delete
rows/columns, Row height / Column width, and Hide / Unhide. Insert and Edit menus show the same
counts. View → Hide rows / Hide columns collapses the selection; Unhide restores
hidden axes in the selection (the whole sheet unhides all). Click the double line
on a header next to a gap to unhide that run. Hidden rows and columns keep their
numbers and still calculate; print skips them, CSV export includes them.
Freeze
View → Freeze keeps the first rows and columns on screen while the rest of the sheet
scrolls. Choose no rows, 1 row, 2 rows, or up to the current row, and the same for
columns.
The grid starts at 50×10 and grows on paste, fill, Go To, or import past the last
row or column. Free: 50 columns × 5,000 rows and 5 sheets. Pro: 200 × 20,000 and
50 sheets.
Sheets
The + next to the tabs adds a sheet. Drag a sheet tab to reorder, or use
Move Left / Move Right on the tab menu.
Double-click a tab, F2, or Alt+1 to rename.
Hide sheet, Unhide (a submenu of hidden names), and Change color are on that menu too
(a color stripe on the tab).
Hidden sheets still calculate but drop off the tab bar; you cannot hide or delete the last
visible sheet.
Alt+Up /
Alt+Down cycle visible sheets.
Find and replace
Edit → Find and replace (Ctrl+F;
Ctrl+H focuses Replace) searches what you
typed, including formulas. Match case and entire cell are optional. Within can be
this sheet, all sheets, or the selection. Replace and Replace all write those
contents back (one undo).
File
CSV
File → Import CSV places a file at the selection. A header like
length (m) turns bare numbers in that column into quantities,
Amount ($) into money, and Price ($/lb) into a price.
File → Export CSV downloads cell contents (formulas and 10m), not
computed values. A multi-cell selection exports that range; otherwise A1 through
the used area.
Print
File → Print prints displayed values for the used area (or the selection if more
than one cell). Use the browser dialog to save a PDF.
