File Corruption & Recovery

How to Recover Accidentally Deleted Excel Cells Without Saving

Algirdas Jasaitis Sep 28, 2026 869 views

Question details

The user needs to recover accidentally deleted cells in an unsaved offline Excel workbook after the standard undo function (Ctrl+Z) failed.

How to Recover Accidentally Deleted Excel Cells Without Saving

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working on an offline workbook, the user accidentally deleted cells using the 'Shift cells up' option, but Ctrl+Z did not restore the data.
Observed behavior: The deleted cells cannot be restored via Ctrl+Z, and the file has not been saved since the accidental deletion occurred.

Before you start

Stop making any new changes to your workbook immediately. Saving the file now will overwrite the previous state and permanently destroy your chances of recovering the deleted cells.

Solution 1Recommended

Close the Workbook Without Saving

The most effective way to undo unrecoverable changes in an unsaved file is to discard the current session and revert to the last saved version.

By closing the file without saving, you are telling Excel to ignore all modifications made since the last time you hit Save. While this will successfully bring back your accidentally deleted cells, please be aware that it will also discard any other intentional edits you made during this current session.

Close the workbook

Click the 'X' icon in the top-right corner of the Excel window, or navigate to File > Close.

Discard unsaved changes

A prompt will appear asking if you want to save changes. Click 'Don't Save' (or 'No').

Reopen the file

Navigate to the folder where your file is stored and open it again. The workbook will load exactly as it was during your last manual save, complete with the cells you accidentally deleted.

Data Loss Warning: This method relies on your last manual save. Any formatting or data entered after that specific save point will be lost.

Solution 2

Restore an Earlier Version Using OneDrive

If your offline file is synced to a OneDrive folder, you may be able to use the cloud's Version History feature to recover the data.

Free Microsoft Office alternative

Prevent Accidental Data Loss with WPS Office's Built-in Auto Backup

Tired of losing unsaved data when Excel's Undo function fails? WPS Office offers a highly reliable, free, and lightweight alternative to Microsoft Office. With its powerful local Auto Backup feature, you can effortlessly recover unsaved edits and deleted cells without relying on cloud synchronization.

1. Download and install: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open your Excel files: Right-click your existing .xlsx or .xls files, select 'Open with', and choose WPS Spreadsheet to continue working flawlessly.
3. Enable Auto Backup: Go to Menu > Settings > Backup Settings to configure local auto-backup, ensuring your spreadsheet progress is always safely stored.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Built-in Local Auto-Backup feature to safeguard against accidental deletions and crashes.Lightweight software that installs quickly and runs smoothly, even on older devices.Familiar tabbed user interface ensuring a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why didn't Ctrl+Z (Undo) restore my deleted Excel cells?

Excel's undo history can be unexpectedly cleared by certain actions, such as running specific macros, performing complex data filtering, saving the document, or even reaching the system's memory limits. Once the undo cache is cleared, Ctrl+Z becomes ineffective.

Can I recover the deleted cells if I accidentally hit Save?

If you saved the file locally after deleting the cells, the new state permanently overwrites the old data. You can only recover the deleted cells if you have a separate external backup or if the file was synced to a cloud service like OneDrive that supports version history.

Does Excel's AutoRecover feature fix manual cell deletions?

No. Excel's AutoRecover is strictly designed to restore files after an unexpected application crash, system freeze, or power failure. It does not allow you to undo manual deletions or edits within an active, stable workbook session.

Document & File Issues