Recover Excel Worksheets Deleted with Ctrl+Y
Question details
Recover Excel worksheets deleted when Ctrl+Y repeated a worksheet deletion.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Ctrl+Y is used after deleting a worksheet, potentially repeating the deletion on another sheet.
- Observed behavior
- Deleted worksheets may not return with Ctrl+Z, and saving the workbook can make recovery more difficult.
Check whether the workbook has been saved since the deletion and whether AutoSave was enabled. Closing without saving discards other unsaved changes, so consider whether those changes are needed before proceeding.
Close the workbook without saving the deletion
Use this method if the workbook has not been saved since the worksheet was deleted.
In Excel, close the affected workbook using the window Close button or File > Close.
When prompted to save, select Don't Save. This discards the deletion and all other changes made since the last save.
Open the workbook again from its original location and check the sheet tabs for the deleted worksheets.

Restore an earlier version of the workbook
Use version history or an earlier copy if the deletion has already been saved.
Work with Excel-compatible spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility helps you move existing files to WPS Office; it does not restore a worksheet deleted in Excel.

Frequently Asked Questions
Can Ctrl+Z restore a deleted worksheet in Excel?
Worksheet deletion cannot be undone with Ctrl+Z in Excel. If the deletion has not been saved, close the workbook and select Don't Save; otherwise, check for an earlier version.
Why did Ctrl+Y delete another worksheet?
Ctrl+Y can repeat the previous action in Excel, including worksheet deletion. Check the remaining sheet tabs and avoid saving if you need to discard an unsaved deletion.
Where can I find an older version of my Excel workbook?
For a OneDrive or SharePoint file, check File > Info > Version History in Excel. On Windows, you can also right-click the file in File Explorer and select Properties > Previous Versions, if earlier versions are available.
Can I recover a deleted worksheet after saving the workbook?
If the deletion was saved, look for an earlier version in Excel's Version History, Windows Previous Versions, or another saved copy. Recovery depends on an intact earlier version being available.
How do I report unexpected Ctrl+Y behavior in Excel?
In Excel, select File > Feedback and describe the worksheet deletion and the actions that preceded it.




