Recover a Deleted Numbers Sheet Without Losing Newer Edits

Quick answer: Open File → Revert To → Browse All Versions and find the missing content. Copy only that content into the current spreadsheet, or hold Option and choose Restore a Copy to inspect a separate historical file. Ordinary Restore replaces the current version, so it is the wrong first choice when newer edits must survive.

Scope and preparation

This guide targets Numbers for Mac 15.4, the edition identified by Apple’s Mac guide when checked on October 16, 2026. Check your installed version in Numbers → About Numbers. These are Mac instructions, not the iPhone, iPad or iCloud interface. English formulas below use commas; a document that uses decimal commas may require semicolons between arguments.

Testing disclosure: The instructions were checked against Apple documentation and the sample results were independently calculated. This workflow has not been tested in the Numbers application; no application screenshots are supplied.

You need the original spreadsheet and an available saved version containing the lost work. This procedure cannot reconstruct a sheet that was never present in a recoverable version. Work slowly if other people are editing the file: coordinate a recovery window so you can distinguish your recovery from their new changes.

Before recovery, save the current work and make a separate safety copy using your normal file-backup method. Keep the original file available: a new copy should not be assumed to carry the original’s version history. Write down the current filename and two or three recent values that must survive. Do not begin by restoring the entire document “just to see.”

A practical recovery target

Imagine a planning workbook that used to contain Budget and Suppliers sheets. The Suppliers sheet disappeared, but you have since revised the Budget sheet.

Current Budget item	Amount that must survive
Venue	640
Catering	360
Printing	75
Total	1075

The historical Budget values were 600, 320 and 75, totaling 995. Restoring that entire historical document would lose 80 of newer revisions. Your aim is to recover these four supplier records while leaving the current budget at 1075:

Supplier ID	Service	Contact label
SUP-A	Venue	Alex
SUP-B	Catering	Morgan
SUP-C	Printing	Taylor
SUP-D	Audio	Jordan

These are synthetic records, not real contacts. No email address or phone number is needed to practice recovery. On a real document, record row counts, key labels and totals without copying private content into an unrelated service.

Find the historical content

1. With the original spreadsheet open, choose File → Revert To → Browse All Versions.
2. The left window represents current work; earlier versions are on the right. Use the timeline or arrows to locate a version before the sheet disappeared.
3. Inspect its Suppliers content. Confirm all four records, not just the existence of a sheet tab.
4. Choose a recovery method below. Done leaves version browsing without replacing current work.

Apple documents the version browser, selective copying and the separate-copy option in Restore an earlier version.

Method 1: copy the missing content only

In the earlier version on the right, select the needed text or table object and use Edit → Copy. In the current version on the left, select the intended destination and use Edit → Paste, then Done. Move the pointer to the top of the screen if the Edit menu is hidden in this view.

For a missing sheet, recover its table objects onto a fresh, clearly named destination sheet rather than pasting over a surviving budget table. If managing a whole sheet in the version browser is awkward, use Method 2. Apple says sheets can be copied from historical versions, but you do not need to rely on an undocumented sheet-tab gesture to rescue the data.

Distinguish a selected table object from selected cells inside a table. A cell paste can overwrite the destination cells. Check the selection and destination before pasting; if you only need a block of records, reserve an empty area large enough for the full block.

Method 2: restore a separate copy for comparison

While the wanted version is displayed on the right, hold Option and click Restore a Copy. Save the newly opened historical copy with a distinct name, such as Planning-recovered-reference. The original stays open separately. Recover only the required objects or records into the current file; retain the historical copy until verification is complete.

This method is useful when the lost sheet has several tables, charts or formula dependencies. Make an inventory in the historical copy first. For example: four supplier rows, one notes box and one chart are three separate things to account for. Merely restoring the main table is not evidence that the whole sheet is back.

Verify both halves of the recovery

A successful recovery has two independent conditions: lost work is present and newer work remains intact.

1. Confirm SUP-A through SUP-D are present exactly once. Check all three columns, not only the first row.
2. Confirm the current budget still contains 640, 360 and 75. Their sum must be 1075, not 995.
3. Inspect recovered formulas. A copied table can depend on objects that were not recovered, and a plausible-looking value does not prove a live reference points to the intended current table.
4. Compare text labels against the historical copy where necessary. EXACT can help with deliberate text comparisons; do not use a total alone to validate identifiers.
5. Save the corrected current file under its intended name. Reopen it and repeat the record-count and budget checks before disposing of your safety copy.

For a numerical checksum, SUM can verify the three budget amounts. For a simple inventory of nonempty supplier identifiers, COUNTA is useful, provided the range excludes the header and contains no formula-generated empty strings. Neither function proves that the right records were recovered: the identifiers still need checking.

When recovery does not behave as expected

• No useful historical version: Stop rather than restoring an unrelated one. Look for an independently saved copy or an existing backup. This guide does not promise that version history is a permanent backup archive.
• The budget reverted to 995: Treat that as a failed selective recovery. Keep the safety copy, identify which window you edited, and recover your current state before trying again.
• You see duplicated table names or broken formulas: Inspect the reference targets and compare against the historical copy. Reconnect deliberately; do not hide the errors with IFERROR merely to make the sheet look clean.
• A collaborator cannot see the needed version: Apple limits editing collaborators to versions created after sharing began; view-only collaborators cannot access earlier versions. Ask an appropriate owner/editor to investigate rather than changing sharing permissions as a troubleshooting shortcut.
• Only the data returned: Formatting, charts, text objects and links require their own verification. CSV exports cannot stand in for a complete Numbers sheet.

The historical copy is a comparison source, not a new authoritative workbook until you intentionally decide otherwise. Keeping clearly distinct filenames prevents an old budget from becoming the file everyone edits next.