Restoring a Deleted Sheet or Tab in Excel
How to bring back a deleted worksheet tab in Excel using undo, unsaved workbook recovery, version history and backup copies, plus a safe habit for backups.
Contents
- Undo the deletion straight away
- Recover a workbook closed without saving
- Use version history and backup files
- Questions about deleted Excel sheets
- How do I restore a deleted sheet in Excel after saving the file?
- Can I recover deleted Excel sheet data that was never saved?
- Why is a worksheet missing but not truly deleted?
- Does the same undo trick work in Google Sheets?
Restoring a deleted sheet or tab in Excel means bringing back a worksheet that was removed from a workbook, so the data on it is available again. The method that works depends on how soon you act and whether the workbook was saved after the deletion. An undo, a closed-without-saving recovery, a backup copy or a stored older version can each return the tab. The steps below cover each route and how to keep a spare copy so the loss is easier to fix next time.
Undo the deletion straight away
The fastest repair for an accidentally deleted spreadsheet tab is the undo command, which sits in the Quick Access Toolbar or responds to Ctrl+Z. Deleting a worksheet counts as one action, so a single undo restores the tab with its contents and formatting. Act before you perform other edits, because each new action is stacked on top of the deletion. Once the workbook is saved after the removal, undo can no longer reach the step.
Recover a workbook closed without saving
Excel keeps a temporary recovery copy of an open workbook, so a file closed by mistake can often be reopened through the document recovery pane. The pane appears when Excel restarts after an unexpected close. Choose the version that carries the latest timestamp before you deleted the tab. Save that recovered workbook under a new name first, then compare the sheets. Recovery depends on settings and the type of close, so treat the option as a chance rather than a certainty.
Use version history and backup files
A stored older version of the workbook can restore a deleted worksheet when the file was saved to a cloud location with version history. Open the version list, preview a copy from before the deletion, and copy the needed worksheet into the current file. A Save As backup copy kept on another drive or folder serves the same purpose when no history exists. Version history depends on where the workbook is stored, so check the location before counting on it.
Questions about deleted Excel sheets
How do I restore a deleted sheet in Excel after saving the file?
A saved workbook no longer responds to undo for the deleted sheet, so Excel needs another source for the tab. Look for a stored previous version in the file location, then copy the worksheet back into the current workbook. Without version history, a backup file is the remaining route to the lost data. Edit the recovered copy under a new name so the current file stays intact.
Can I recover deleted Excel sheet data that was never saved?
Unsaved deletions can often be recovered through the document recovery pane that Excel shows after an unexpected close. Pick the recovered version that lists the worksheet you lost, then save it as a separate file. If Excel closed normally, the recovery copy may not exist, so check the file location for a temporary version. Save the recovered workbook before you make further edits.
Why is a worksheet missing but not truly deleted?
A worksheet can look missing when it is hidden rather than deleted, and an unhide step brings it back. Right-click any visible tab, choose the unhide option, and select the name from the list. Hidden tabs keep all their data, so nothing is lost while the sheet stays out of view. If the name does not appear in that list, the tab was removed and needs a restore route.
Does the same undo trick work in Google Sheets?
Google Sheets offers its own undo control that reverses a tab deletion while the change is still recent. The application also keeps version history, which lists earlier states of the file and lets you restore one. Sheet tabs deleted in Google Sheets do not appear in the Excel recovery pane. Use the version list in that application when undo no longer reaches the deletion.