Back to All Cheatsheet Libraries cheatsheets

Apple Numbers

Keyboard shortcuts, formulas, and multi-table reference for Apple Numbers.

A sheet is a canvas, not a grid

This is the single thing that separates Numbers from Excel and Google Sheets, and it confuses everyone coming from them. In Excel, the sheet is one enormous grid. In Numbers, a sheet is a blank page onto which you place tables as objects — several per sheet, each with its own headers, sizing, and formatting, positioned wherever you like alongside charts, text, and images.

It makes Numbers far better for building something a human reads — a report, an invoice, a budget summary — and noticeably worse for a 50,000-row data dump. Choose accordingly.

Concept In Numbers Excel equivalent
SheetA canvas holding any number of tables, charts, and objects.A worksheet, which is itself a single grid.
TableA discrete object with its own header rows and columns.Closest to a named Excel Table (Ctrl+T), but mandatory here.
Header row/columnA real structural property; formulas reference them by name.Just the top row, by convention.
Cell referenceTable 1::B2 across tables; names used where headers exist.Sheet1!B2
CategoryGroup rows by a column value, with automatic subtotals.Roughly a PivotTable, though simpler and live in place.
Pivot tableAvailable since Numbers 11 — Organize → Pivot Table.PivotTable, with far more options.
Working with tables as objects
  • Click a table once to select it as an object; click again to enter it and edit cells.
  • The circle at the top-left corner selects the whole table — drag it to reposition on the canvas.
  • Name your tables. Double-click the table name and give it something meaningful — cross-table formulas read as Expenses::Total rather than Table 3::D14.
  • Header rows and columns are set in Format → Table. Freezing them is a single toggle, not a special view mode.
  • Multiple small tables beat one huge one — that's the design Numbers is built around.
Categories, sorting and filtering
  • Organize → Categories groups rows by a column value and shows subtotals per group automatically — the feature most worth learning.
  • Add a second category level for nested grouping.
  • Summary rows offer sum, average, count, min, max per group from a dropdown; no formula needed.
  • Organize → Sort and Filter apply per table, and filters are non-destructive.
  • Quick filter: click a column's dropdown arrow → Filter.
Group Action Shortcut
EditStart a formula in the selected cell=
EditEdit the selected cell in placeReturn or double-click
EditConfirm and stay in the same cell⌥ + Return
EditCancel the current editEsc
EditLine break inside a cell⌥ + Return while editing text
EditPaste and match style⌥ + ⇧ + ⌘ + V
EditPaste formula results only⇧ + ⌘ + V
SelectSelect the whole table⌘ + A inside it
SelectExtend selection⇧ + Arrow
SelectJump to edge of data⌘ + Arrow
RowsAdd a row above / below⌥ + ↑ / ↓ with a row selected
RowsAdd a column left / right⌥ + ← / → with a column selected
FormatToggle the Format sidebar⌥ + ⌘ + I
FormatBold / italic / underline⌘ + B / ⌘ + I / ⌘ + U
FormatCopy / paste style⌥ + ⌘ + C / ⌥ + ⌘ + V
ViewFind / replace⌘ + F / ⌥ + ⌘ + F
ViewZoom in / out⌘ + > / ⌘ + <
ObjectsLock / unlock⌘ + L / ⌥ + ⌘ + L

Referencing works by name, not just by letter

When a table has header rows and columns, Numbers writes formulas using those names. It produces formulas that are genuinely readable, and it means inserting a row doesn't break anything.

# Within one table — Numbers writes the header name automatically =SUM(Amount) # One cell in another table =Expenses::B2 # A whole column in another table =SUM(Expenses::Amount) # Absolute reference (lock row and column) =$B$2 # Conditional sum =SUMIF(Category, "Travel", Amount) =SUMIFS(Amount, Category, "Travel", Month, "March") # Lookup — XLOOKUP exists in current versions and is the better choice =XLOOKUP("Widget", Products::Name, Products::Price) =VLOOKUP("Widget", Products::A:C, 3, FALSE) # Count matching rows =COUNTIF(Status, "Complete") # Guard against errors =IFERROR(A2/B2, 0) # Text join =CONCATENATE(First, " ", Last) # or: =First & " " & Last
Formula behaviour worth knowing
  • Cross-table references use a double colon: TableName::CellOrColumn.
  • Typing a formula into a header-equipped column auto-fills the entire column — that's the default, unlike Excel.
  • Toggle absolute/relative with ⌘ + K while the reference is selected in the formula editor.
  • Numbers has around 250 functions against Excel's 450-plus. Most everyday ones are present; specialist statistical and financial functions may not be.
  • There is no macro language. Automation happens through AppleScript or Shortcuts, not VBA.
  • Renaming a table updates every formula referencing it automatically.
Charts
  • Select the data, then the Chart button. Charts are objects on the canvas and can sit on a different sheet from their data.
  • Interactive charts add a slider that steps through a data series — a genuinely distinctive Numbers feature, good for presentations.
  • Edit References on a chart lets you change the source range without rebuilding it.
  • Charts copy cleanly into Keynote and Pages and stay editable there.

Tips

Name every table

Double-click the table name. Formulas become SUM(Expenses::Amount) instead of an opaque cell range — the single easiest habit for making a spreadsheet maintainable.

Cell controls

Format → Cell → Data Format offers checkbox, star rating, slider, stepper, and pop-up menu. A pop-up menu is Numbers' data validation, and it makes entry forms genuinely pleasant.

Categories over pivot tables

Organize → Categories gives grouped subtotals in place, live, with no separate object to refresh. Faster than a pivot table for most summarising.

Check the print view early

File → Print shows page breaks over the canvas and lets you scale to fit. Because sheets are canvases, printing needs more attention here than in Excel — check it before you finish designing.

Version history

File → Revert To → Browse All Versions for any iCloud-saved document. Restores an earlier state without keeping manual copies.

Forms on iPhone and iPad

The mobile apps can generate a form from a table for one-record-at-a-time entry. Ideal for collecting data in the field; the rows appear in the table as normal.

Gotchas & limits

Excel interoperability
  • Numbers opens and exports .xlsx, but the canvas model does not map cleanly. Several tables on one Numbers sheet become several ranges on one Excel worksheet, and the layout is not preserved.
  • Functions Numbers lacks arrive as errors; macros are dropped entirely.
  • Conditional formatting and data validation translate only partially.
  • Don't use Numbers as a staging tool for a shared Excel workbook. If the file's home is Excel, work in Excel.
  • Export to CSV for pure data handoff — lossless for values, and it sidesteps every conversion problem.
Scale limits
  • Numbers slows noticeably well before Excel does. Tens of thousands of rows is where it starts to struggle.
  • Because tables are objects with individual formatting, large tables carry more overhead per cell than a plain grid.
  • No Power Query equivalent, no external data connections, no data model.
  • For large datasets or repeatable data pipelines, use Excel or a database. Numbers is for spreadsheets people read.
Small surprises
  • Clicking once selects the table object; you need a second click to edit cells. This catches every Excel user on day one.
  • Deleting a table deletes its data with no separate confirmation beyond the standard undo.
  • A formula typed into a column with a header fills the whole column by default — useful, but surprising if unexpected.
  • Numbers is free on all current Apple devices and runs in any browser at icloud.com/numbers.

Resources

Numbers User Guide for Mac Apple's complete official manual for the current release. support.apple.com Formulas & Functions guide Every supported function with syntax and worked examples. support.apple.com Keyboard shortcuts The full macOS shortcut reference. support.apple.com Numbers for iCloud Browser version — how Windows collaborators open a Numbers file. icloud.com Microsoft Excel The right tool when the dataset is large or the file's home is Excel. build.ty1er.com Apple Pages Shares the same Format sidebar, object placement, and styles model. build.ty1er.com

Numbers is free on Mac, iPad, and iPhone, and runs in any browser via iCloud. It has no macro language — automate with AppleScript or Shortcuts. For large datasets, repeatable data pipelines, or files that live in Excel, use Excel rather than converting back and forth.