To undo a deleted sheet tab in Excel for Microsoft 365 on Windows, press Ctrl+Z as soon as you can, or select Undo on the Quick Access Toolbar. Excel should bring back the deleted worksheet, including its contents. If Undo is no longer available, check the workbook’s version history or a backup; Excel does not have a separate recycle bin for individual sheet tabs.
These steps apply to a worksheet deleted from an open workbook. They do not apply if you only hid the tab, renamed it, or deleted the entire workbook file. If the sheet may contain important data, avoid making more changes until you have tried the recovery steps.
What You’ll Need
- The workbook that contained the deleted worksheet, preferably still open in Excel.
- Access to the workbook’s version history if it is stored in OneDrive or SharePoint, or access to a backup if it is stored locally.
- For recovery attempts involving an earlier workbook version, a safe place to save a copy of the current file.
Step-by-Step
- Check whether the tab was deleted or just hidden. Look along the bottom of the Excel window for the worksheet tabs. If the tab is missing but you are not sure it was deleted, right-click any visible sheet tab and choose Unhide. If the sheet appears in the list, select it and choose OK. A hidden sheet is still part of the workbook; an actually deleted sheet will not appear in the Unhide list. If you do not see any tabs, the worksheet-tab display may be turned off, so check Excel’s display settings before assuming the sheet is gone.
- Undo the deletion immediately. In Excel for Microsoft 365 on Windows, press Ctrl+Z. Alternatively, select the left-curving Undo arrow on the Quick Access Toolbar near the top of the window. If you performed another action after deleting the sheet, the first Undo may reverse that later action; press Undo again as needed until the deleted tab returns. Watch the workbook after each undo so you can stop as soon as the correct sheet is restored.
- Use the Undo list if you need to find the deletion. Select the small arrow beside the Undo button to view recent actions, when that list is available. Locate the worksheet deletion and select it. Excel will undo that action and the actions listed above it as well, so check whether anything else will be reversed. The Undo list is not a permanent history: it only contains actions Excel can currently undo in the open session.
- Confirm that the worksheet and its contents are back. Check the tab name, then open the sheet and verify a few important cells, formulas, and formatting. If the workbook had multiple sheets with similar names, make sure you restored the correct one. A restored worksheet should return as part of the workbook, not as a separate file.
- Save after confirming the recovery. Press Ctrl+S on Windows. If you want to protect the recovered copy without replacing the existing file, use File > Save As and save it under a new name or in a separate location. This gives you a fallback if you later discover that you restored the wrong action or workbook state.
- If Undo is unavailable, check version history for a cloud workbook. For a workbook saved in OneDrive or SharePoint, open File > Info > Version History in the Windows desktop app. Review versions from before the sheet was deleted and open an appropriate one. The exact version-history controls can vary with your Microsoft 365 setup. In Excel for the web, open the workbook’s version history from the file information or file menu; in OneDrive or SharePoint, you can also find Version history from the file’s menu.
- Preserve the current file before restoring an older version. Version history is generally a record of the workbook as a whole, not a way to restore only one deleted tab. Before choosing to restore, save a copy of the current workbook if you need to keep its latest edits. Then open the earlier version, check that it contains the missing worksheet, and use the available restore option only if you are comfortable replacing the current workbook state. If you only need the old sheet, you may be able to copy it from the earlier version into a copy of the current workbook instead.
- Look for a backup if the workbook is stored locally. Check any backup location or file-copy system you use, such as a manually saved duplicate or your organization’s backup service. Open a candidate copy and confirm it includes the missing worksheet before using it. If you do not have a backup, check Excel’s recovery options, but treat them as a possibility rather than a guaranteed way to retrieve a deleted tab.
Common Mistakes
- Waiting until after closing the workbook. Undo is designed for recent actions in the current editing session. Closing the workbook or ending the session may remove the available undo history. If you notice the deletion, try Undo before closing Excel.
- Making many edits before trying to recover. New actions can make it harder to locate the deletion in the Undo list, and undoing a group of actions may also remove later work. Stop editing, inspect the list, and consider saving a separate copy before using a long sequence of undos.
- Choosing Unhide for a deleted sheet. Unhide only works for worksheets that still exist in the workbook but are hidden. If the sheet is absent from the Unhide list, use Undo, version history, or a backup instead.
- Restoring an older workbook without keeping the current one. An earlier version can bring back the sheet but may also remove newer changes to other sheets. Make a copy of the current file first, then compare versions or copy just the needed worksheet where practical.
- Assuming AutoRecover is a sheet-level restore tool. AutoRecover and unsaved-workbook recovery are intended to help with unsaved work or unexpected closure. They may not contain a useful copy of a workbook after a saved sheet deletion, and they cannot promise recovery of that tab.
Tips
- Act before doing anything else. The quickest, least disruptive recovery is usually the first Undo. Avoid closing the workbook, switching to a different file, or making unrelated edits while you decide what to do.
- Use the right shortcut for your device. Windows uses Ctrl+Z. Excel for Mac uses Command+Z. Excel for the web also supports Undo; the keyboard shortcut depends on your device, and the Undo button on the toolbar is a useful alternative.
- Save a recovered copy under a clear name. A name such as Budget_recovered can help distinguish the restored file from the working copy. Keep the original until you have checked formulas, links, and other recent edits.
- Make regular copies of important workbooks. OneDrive and SharePoint version history can provide earlier file states, while separate backups provide another recovery route. For a critical workbook, make sure you know where its backups are and how to open an earlier copy before you need one.
- Check the tab before deleting it. If you only need to remove a sheet temporarily, consider hiding it rather than deleting it. Hiding keeps its data in the workbook and lets you use Unhide later; deletion removes the worksheet from the workbook.
Troubleshooting
Ctrl+Z does nothing or is unavailable: Select the Undo button and check whether it is disabled. If it is disabled, Excel may no longer have the deletion in its undo history, or the action may not be undoable in the current context. Do not keep pressing random shortcuts. If the file is cloud-stored, check Version History; otherwise, look for a backup or a previous copy.
Undo reverses the wrong action: Excel undoes actions in reverse order. If you typed, formatted, or changed something after deleting the tab, Undo may reverse that work before it reaches the deletion. Continue only if you are comfortable losing those intervening changes. If not, save a separate copy first and consider using version history to compare workbook states.
The earlier version does not show the sheet: Choose a version from before the deletion, not merely the most recent version available. Open it and inspect the worksheet tabs before restoring anything. If none of the listed versions contains the sheet, check other backup locations or ask your Microsoft 365 administrator whether organization-level backups are available.
You cannot find Version History: The workbook may be saved only on your computer, or your account or organization may not provide cloud version history for that file. Confirm the save location in Excel. For a local workbook, check saved copies and backup tools; Excel’s recovery features are not a substitute for a prior saved version.
You restored a version but lost newer edits: If you saved a copy first, reopen that copy and move over any needed recent work. To copy a worksheet between open workbooks, right-click its tab and choose Move or Copy, select the destination workbook, and select Create a copy if you want to keep the original sheet in place. Review formulas and links afterward, especially if they refer to other sheets.
Frequently Asked Questions
Can I recover a deleted Excel tab after saving?
Often, yes, if the workbook is still open and the deletion remains in the Undo history. Try Ctrl+Z on Windows or Command+Z on Mac. If Undo is no longer available, use a cloud version or backup from before the deletion.
Does closing Excel permanently delete my chance to undo?
It can remove the undo history for that session, so do not rely on Undo after closing the workbook. A saved cloud version or backup may still let you recover an earlier workbook state.
Can I restore just one sheet from Version History?
Version History usually saves versions of the entire workbook, not individual worksheets. You can open an earlier version and, where appropriate, copy the needed sheet into a copy of the current workbook instead of replacing the whole file.
Is a deleted sheet in the Recycle Bin?
No. The Recycle Bin is for deleted files, not individual worksheets removed from a workbook. For a sheet, use Undo, version history, or a backup of the workbook.
What if the worksheet is missing but was only hidden?
Right-click a visible sheet tab, choose Unhide, select the worksheet, and choose OK. If the sheet is not listed, it may have been deleted or may not exist in that copy of the workbook.
Can AutoRecover bring back a deleted worksheet?
Possibly, if a useful recovered copy exists from before the deletion, but AutoRecover is not a guaranteed method for retrieving a saved, deleted tab. Check version history and backups as well.
Related
- How to Split an Excel Sheet in Half Without Losing Data
- How to Split an Excel File in Half: A Step-by-Step Guide
- How to Split an Excel File Into Smaller Files Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Not Printing All Rows? Fix the Print SettingsIf Excel is not printing all rows, check that File > Print is not set to print only…
- Print Area in Excel: Set, Change, and Fix ItA print area in Excel is a selected range of cells that Excel prints, leaving cells outside that…
- Microsoft Excel Spill Error: Causes and FixesMicrosoft Excel’s #SPILL! error means a formula is trying to return multiple results, but Excel cannot place the…
- Excel Data Table Not Working? Fix Blank ResultsIf an Excel what-if Data Table shows blank results, first check that its source formula actually returns a…
- Excel IRR #DIV/0! Error: Why It Happens and How to FixIf Excel shows #DIV/0! beside IRR, the error is usually in one of the cash-flow formulas or cells:…
- Excel SUM Total: How to Add Cells and Fix ErrorsTo calculate a total in Excel, use the SUM function: with amounts in B2:B10, enter =SUM(B2:B10) in an…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.