Create snapshots of a table for a report in Apple Numbers

Quick answer: Select the whole table and choose Edit → Copy Snapshot, then paste it onto an empty part of the sheet. A snapshot preserves displayed table values and formatting without retaining formulas, categories, or hidden values. It will not update when the source changes.

When to use this

Use a snapshot for a fixed report checkpoint, not as the next calculation model. This guide covers Numbers 15.4 for Mac. It deliberately keeps the original table and its snapshots in the same private spreadsheet so you can compare them without sending data to another app or person.

Create a Blank spreadsheet and use its first table with one header row, four columns, and three rows. Name the table Orders. Enter:

Row	A: Item	B: Quantity	C: Unit cost	D: Line cost
1	Item	Quantity	Unit cost	Line cost
2	Notebook	3	4	=B2*C2
3	Folder	2	5	=B3*C3

D2 and D3 should display 12 and 10. The two records total 22. Leave every column and row visible, with no filters or categories. Save snapshot-before.numbers in a local Numbers Practice folder, then use File → Save As for snapshot-work.numbers. For basic table setup, see Numbers tables, rows, and columns.

Capture the first checkpoint

1. Select Orders as a whole table, not just D2. The task is to capture its headings and both records.
2. Choose Edit → Copy Snapshot from the menu bar.
3. Click empty canvas to the right of Orders and choose Edit → Paste. Keep enough separation to see both tables.
4. Rename the pasted table Report before change. Inspect the headings and the 12 and 10 line costs.
5. Click a line-cost cell in the pasted table and inspect its contents. The snapshot holds the result, not the original =B2*C2 calculation.

The snapshot is a table copy, not a fabricated application screenshot or a promise that every hidden part of the source was captured. Apple explicitly excludes hidden values, formulas, and categories. With this all-visible fixture, the expected report contains both records and all four columns.

Prove that it is independent

In the original Orders table, change B2 from 3 to 4. Its D2 becomes 16; D3 remains 10, so the source now totals 26. Report before change must still show quantity 3 and line cost 12 for Notebook, with a total of 22 across its two costs.

Do not type 16 into the old snapshot to make the two tables agree. Their intentional disagreement demonstrates the checkpoint boundary. If the old copy changed automatically, inspect whether you pasted ordinary references or copied the wrong object instead of using Copy Snapshot.

Create a second snapshot from Orders after that edit. Paste it on separate canvas and name it Report after change. It should contain 16 and 10, totaling 26. The workbook now contains one calculation table and two clearly named reporting checkpoints. Names explain why their numbers differ.

Grow the source and capture only what you intend

Add one body row to Orders. Enter Pencil, 5, and 2 in A4:C4, with =B4*C4 in D4. The new line cost is 10; the source total is now 36. Both earlier snapshots should remain unchanged and should still contain only two body records.

For an optional third checkpoint, select Orders again and repeat Copy Snapshot. Name the new table Report with Pencil; check three records and costs 16, 10, and 10. This also tests whether you selected the original rather than copying an earlier snapshot by mistake.

When reporting a pivot or categorized table, first decide which visible groups, fields, and totals belong in the report. Snapshotting does not preserve the original pivot or category controls as an analysis tool. Keep the editable source elsewhere and label the report’s capture date. See pivot table basics for the calculation workflow that precedes a report.

Save and recover safely

Use File → Save As to save snapshot-final.numbers, then reopen it. Verify the source’s three records, the original 22-total checkpoint, and the later 26 checkpoint. If you created the third report, verify its total of 36 too. These are expected reader checks; no native Numbers execution is claimed here.

To practise again, make a new working copy of snapshot-before.numbers. Do not rely on Undo after reopening, and do not rebuild the source from the snapshot when formulas are required. If values are missing, investigate hidden rows, hidden columns, or the selected source before treating the report as complete. When pasting into another application later, inspect that destination’s actual output and access permissions separately.

Documentation and verification

Apple’s version-pinned 15.4 guides below were retrieved on 20 October 2026, except the table-row guide reused from 19 October where cited. The worked scenario and arithmetic are independently checked, not native application tests. Save/reopen, synchronization, media playback, and device behavior must be verified on your own installation. No native screenshots are supplied.

• Numbers User Guide for Mac
• Create a snapshot of a table in Numbers on Mac
• Save and name a spreadsheet in Numbers on Mac
• Add or remove rows and columns in Numbers on Mac