How to Recover Deleted Excel Messages or Cell Content
Question details
The user needs to restore cell values, data, or messages that were accidentally deleted from an Excel worksheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accidentally deleting important data, cell values, or attached messages while editing a spreadsheet.
- Observed behavior
- The targeted cell content, notes, or messages are missing and need to be restored to their previous state.
Stop making further edits to your spreadsheet immediately. Typing or saving new changes can overwrite the temporary data needed to restore your deleted content.
Use the Undo Command for Immediate Recovery
The fastest way to recover deleted cell content or messages if you haven't closed the file.
If you just deleted the data and the Excel workbook is still open, the built-in Undo feature is your best option. This method will not work if the file has been closed.
Find the Quick Access Toolbar at the top left corner of your Excel window, just above the ribbon.
Click the Undo arrow button, or press the keyboard shortcut 'Ctrl + Z' (Windows) or 'Cmd + Z' (Mac).
Repeat the shortcut or click the drop-down arrow next to the Undo button to select and reverse multiple recent actions until the deleted message or cell content reappears.
Restore a Previous Version from Cloud Storage
Ideal for recovering saved files stored on OneDrive or SharePoint.
Recover via Windows File History
Use this method if the file is saved locally and you have Windows File History enabled.
Protect and Recover Your Data Easily with WPS Office
WPS Spreadsheet provides robust auto-backup and cloud syncing features to ensure you never lose important cell data again. It offers built-in tools to recover your work instantly, all while being fully compatible with Microsoft Excel formats.
- 1. Use Immediate Undo: Open your spreadsheet in WPS Office. To undo recent deletions, simply press 'Ctrl + Z' or click the Undo arrow on the top toolbar.
- 2. Access Local Auto-Backup: If the file is saved and closed, click 'Menu' in the top-left corner, go to 'Backup and Recovery', and select 'Auto Backup' to find automatic local snapshots of your file.
- 3. Restore Cloud Versions: For files saved to WPS Cloud, click the 'File' tab and select 'Version History' to preview and restore an earlier state with your data intact.
Frequently Asked Questions
Can I recover deleted Excel content after saving and closing the file?
If the file is stored locally without backups, standard Undo is no longer available once closed. However, if you use cloud storage (OneDrive, SharePoint, or WPS Cloud) or have Windows File History enabled, you can easily restore a previous version of the document.
Where are Excel AutoRecover files saved?
By default, Excel saves AutoRecover files in a hidden AppData folder, usually located at 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\'. You can access these by opening Excel, going to File > Info > Manage Workbook, and clicking 'Recover Unsaved Workbooks'.
Does 'Ctrl + Z' work for deleted comments or messages in Excel?
Yes, if you accidentally delete a cell comment, note, or error message prompt, pressing 'Ctrl + Z' immediately will restore it, provided you haven't made other significant changes or closed the document.
How do I recover a deleted message from another messaging application linked to Excel?
If you are referring to a deleted email or chat message that contained Excel data, you must use the recovery features of that specific email client (like checking the 'Deleted Items' folder in Outlook) or messaging service, as Excel cannot retrieve data deleted outside its application.
