如何恢復已刪除的 Excel 表指南

2025 年 12 月 24 日
如何恢復已刪除的 Excel 表指南

Accidentally deleting a worksheet can remove formulas, reports, charts, or business data in seconds. Fortunately, you may still be able to 復原已刪除的 Excel 工作表 content if an earlier workbook version exists, Excel created a recovery copy, or the original Excel file remains recoverable. However, the correct method depends on what you deleted: a worksheet tab inside Excel or the entire .xlsx 或 .xls workbook.

本指南說明刪除 Excel 工作表時實際會發生什麼情況，更重要的是，刪除哪些工作表。 文件復原方法 真正有效。首先，您將學習 Excel 和 Windows 提供的可靠的內建復原選項。只有在這些選項都用完之後，我們才會解釋何時需要專門的復原軟體，以及為什麼。 Magic Data Recovery 在特定情況下，可以是一個實用的解決方案。.

下載 Magic Data Recovery

支援 Windows 7/8/10/11 和 Windows Server

想知道您的檔案是否可以復原嗎？ 找出  透過以下的快速檢查，您可以在幾秒鐘內完成檢查。.

資料復原評估
資料復原驗證 ▼

資料復原評估

回答 3 個快速問題以估計您的復原機會

1.發生何種類型的資料遺失？
意外刪除
格式化
分割損失
系統當機
2.遺失後，您有寫入新的資料嗎？
是
沒有
不確定
3.資料遺失發生在哪裡？
硬碟機
固態硬碟機
USB 磁碟機
SD 卡

目錄

Before You Recover Deleted Excel Sheet Data: Check What Was Lost

An Excel workbook is the complete .xlsx, .xls, 或 .xlsm file. A worksheet, also called a sheet or tab, exists inside that workbook. Therefore, deleting one worksheet does not send a separate file to the Windows Recycle Bin.

發生了什麼事？

最佳的第一步

A sheet tab disappeared

Check whether it is hidden

You deleted a sheet but have not saved

Close without saving, then reopen

You deleted a sheet and already saved

Check Version History

Excel 當機了

Use Document Recovery or AutoRecover

The workbook is in OneDrive/SharePoint

Check cloud Version History

The entire Excel file was deleted

檢查回收站

The file is not in the Recycle Bin

Use backups or recovery software

Method 1: Recover Deleted Excel Sheet by Checking Hidden Tabs

First, confirm that the worksheet is really deleted. Sometimes a user hides a tab accidentally and assumes Excel removed it.

  1. 開啟工作簿。.
  2. Right-click any visible sheet tab.
  3. 選擇 Unhide.
  4. Select the missing worksheet.
  5. 鍵點選 OK.

Also check File > Options > Advanced and confirm that Show sheet tabs 已啟用。.

方法 2： Recover Deleted Excel Sheet Before Saving

If you deleted a worksheet after the last save and have not saved again, return to the last intact workbook version.

  1. Stop editing the workbook.
  2. Close Excel.
  3. When Excel asks whether to save changes, choose 請勿儲存.
  4. Reopen the workbook.
  5. Check whether the deleted worksheet has returned.

However, this method also removes other unsaved edits made after the last save. Therefore, copy any important new values elsewhere before closing if you still need them.

For this scenario, preserving the last saved workbook usually gives you the cleanest way to 復原已刪除的 Excel 工作表 data before the deletion becomes part of the saved file.

方法 3： Recover Deleted Excel Sheet After Saving with Version History

If you already saved the deletion, closing without saving will not restore the sheet. However, an older workbook version may still contain it.

For a workbook stored in OneDrive or SharePoint:

  1. 開啟工作簿。.
  2. 前往 檔案 > 資訊 > 版本歷史.
  3. Find a version from before the deletion.
  4. Open it and confirm the missing sheet exists.
  5. Restore that version or copy the required data into the current workbook.

Microsoft documents Version History for Excel files stored through OneDrive and SharePoint. It also warns that restoring an older version replaces the current version, so inspect the old copy first.

As a result, Version History is one of the strongest built-in ways to 復原已刪除的 Excel 工作表 content after saving.

方法 4： Recover Deleted Excel Sheet with AutoRecover

If Excel crashed, lost power, or closed unexpectedly, AutoRecover may contain a recent workbook state. Microsoft explains that Excel can save recovery information automatically when AutoRecover is enabled.

First, reopen Excel and look for the 文件復原 pane. Next, open the most relevant recovered workbook and check for the missing worksheet. You can also use:

檔案 > 資訊 > 管理工作簿 > 復原未儲存的工作簿

Then save any useful recovered copy under a new name. AutoRecover does not replace normal backups. Nevertheless, it can help 復原已刪除的 Excel 工作表 content after an unexpected shutdown.

Method 5: Recover Deleted Excel Sheet from Previous Versions

For a locally stored workbook, Windows Previous Versions or File History may provide an older copy if Windows created one earlier.

  1. Find the workbook in File Explorer.
  2. 按一下滑鼠右鍵，然後選擇 屬性.
  3. 開啟 先前版本.
  4. Select a copy from before the deletion.
  5. Open or copy it before replacing your current file.

If a usable previous copy exists, this method can 復原已刪除的 Excel 工作表 data, including formulas and formatting.

Method 6: How to Retrieve Deleted Excel Sheet Not in Recycle Bin

許多使用者搜尋 how to retrieve deleted excel sheet not in recycle bin, but this query can describe two different problems.

If you deleted only a worksheet tab, it will never appear separately in the Recycle Bin. Instead, use the last saved workbook, Version History, AutoRecover, or Previous Versions.

However, if “Excel sheet” means the entire workbook file, determine whether Windows permanently deleted the .xlsx 或 .xls file. Shift+Delete, an emptied Recycle Bin, or deletion from some external storage devices can remove the normal restore option.

At this point, stop adding files to the affected drive because new writes can overwrite recoverable file data. Next, check backups. If no intact copy exists, file recovery software becomes a reasonable next step.

Method 7: Recover a Deleted Excel File with Magic Data Recovery

Magic Data Recovery becomes relevant when the entire Excel workbook is missing rather than one internal worksheet. For example, you may need it after permanent deletion, an emptied Recycle Bin, or accidental loss from a USB drive.

Importantly, Magic Data Recovery does not directly undelete one worksheet from inside a workbook that you already saved. Instead, it scans storage for recoverable Excel files. If it finds an older workbook copy that still contains the missing tab, you can restore that file and then copy the required worksheet.

為什麼 Magic Data Recovery 適合此情況

Magic Data Recovery supports .xlsx files and common document formats. Its workflow lets users select a drive, scan for lost data, preview supported files, and recover selected items to another location. It also supports common storage media such as internal drives, external drives, USB drives, and memory cards.

How to Recover the Workbook

When standard recovery methods fail, Magic Data Recovery can help retrieve deleted Excel files from storage devices while minimizing further data loss.

步驟 1：下載並安裝 Magic Data Recovery

下載 Magic Data Recovery，並將其安裝到與最初儲存 Excel 檔案的磁碟機不同的磁碟機上。在同一個磁碟機上安裝有覆寫可復原資料的風險。.

下載 Magic Data Recovery

支援 Windows 7/8/10/11 和 Windows Server

步驟 2：選取要掃描的磁碟機

啟動軟體，選擇刪除 Excel 檔案的磁碟或磁碟分割。這可能是系統磁碟機、外部磁碟機或 USB 儲存裝置。.

使用 Magic Data Recovery 復原已刪除的 excel 表單

步驟 3：掃描刪除的 Excel 檔案

Magic Data Recovery 會自動執行進階掃描。隨著掃描的進行，可復原的 Excel 檔案會即時出現，讓您可以找出 .xlsx 或 .xls 檔案的效率。.

等待掃描

步驟 4：復原前預覽 Excel 檔案

還原檔案前，請使用預覽功能驗證檔案內容。此步驟有助於確認復原的檔案是否仍包含遺失的工作表。.

預覽檔案

步驟 5：將檔案復原至安全位置

選擇所需的 Excel 檔案，並將它們儲存到不同的磁碟機。避免將資料還原到原始位置，以降低損毀的風險。.

檔案復原

Tips After You Recover Deleted Excel Sheet 資料

After recovery, keep AutoRecover enabled, use Version History when available, create regular backups, and save a new workbook version before restructuring important sheets. In addition, avoid keeping business-critical data in only one copy. Microsoft also recommends regular saving and backups rather than relying on AutoRecover alone.

為何 Excel 工作表復原有時會失敗

即使有多個復原路徑，有些嘗試還是會失敗。常見原因包括

  • 您在刪除檔案後儲存檔案，這會覆寫其內部資料。.
  • 固態硬碟機 調整 永久移除未使用的資料區塊。.
  • Excel 自動清除臨時檔案。.
  • 雲端同步取代舊版檔案。.

當這些條件適用時，內建的復原選項就無法再可靠地運作。.

總結

最好的方法是 復原已刪除的 Excel 工作表 content depends on when you noticed the deletion. If you have not saved, close without saving and reopen the last intact copy. If you already saved, check Version History, AutoRecover, or Previous Versions first.

針對使用者搜尋 how to retrieve deleted excel sheet not in recycle bin, remember that a worksheet tab never enters the Recycle Bin by itself. However, if the entire workbook was permanently deleted and backups cannot restore it, Magic Data Recovery offers a practical next step by scanning storage for recoverable Excel files and allowing you to preview supported results before recovery.

We recommend Magic Data Recovery because it addresses the specific problem that built-in Excel 復原 cannot solve: a lost or deleted workbook with no usable saved version. That narrow recommendation keeps the recovery process accurate and trustworthy.

下載 Magic Data Recovery

支援 Windows 7/8/10/11 和 Windows Server

恢復已刪除的 Excel 工作表 - 常見問題

Can I recover a deleted Excel sheet after saving?

Yes, you may still recover deleted Excel sheet data after saving if an older workbook version exists. First, check OneDrive or SharePoint Version History. Next, review Windows Previous Versions, File History, or an AutoRecover copy. Open the older version and confirm that it contains the missing worksheet before replacing your current workbook.

Can Ctrl+Z recover a deleted worksheet in Excel?

Do not depend on Ctrl+Z as your main recovery plan. If you deleted the worksheet after the last save and have not saved again, close the workbook without saving and reopen it. However, if you already saved the deletion, use Version History, AutoRecover, Previous Versions, or another earlier workbook copy instead.

How do I recover an Excel sheet that is not in the Recycle Bin?

A worksheet tab never goes to the Windows Recycle Bin because it exists inside the workbook. To recover deleted Excel sheet content, check the last saved workbook, Version History, AutoRecover, or Previous Versions. If the entire Excel file is missing, then check backups or scan the storage device with file recovery software.

Where can I find Excel AutoRecover files?

Open Excel and go to File > Options > Save to view the AutoRecover file location. In addition, try File > Info > Manage Workbook > Recover Unsaved Workbooks. Available recovery files depend on your Excel settings, version, and whether Excel created a usable recovery copy before the worksheet disappeared.

Can Magic Data Recovery restore one deleted worksheet?

Not directly. Magic Data Recovery works at the file and storage level, so it looks for recoverable Excel workbooks rather than undeleting one internal worksheet from an already saved file. However, if it recovers an older workbook copy that still contains the missing tab, you can open that copy and restore the worksheet.

What should I do after permanently deleting an Excel file?

First, reduce activity on the affected drive because new writes can overwrite recoverable data. Next, check OneDrive, File History, backups, or other saved copies. If none exists, scan the original storage device with a recovery tool such as Magic Data Recovery and save any recovered workbook to a different drive.

What is the safest way to recover a deleted worksheet?

Start with the least invasive method. If you have not saved since deleting the sheet, close without saving and reopen the workbook. If you already saved, use Version History or another previous copy. Finally, use storage-level recovery software only when the entire workbook is missing, because worksheet recovery and deleted-file recovery solve different problems.

Vasilii 是一位在該領域擁有約 10 年實務經驗的資料復原專家。在他的職業生涯中，他已成功解決數千個複雜的個案，包括刪除的檔案、格式化的硬碟機、遺失的磁碟分割和 RAW 檔案系統。他的專業知識涵蓋使用十六進位編輯器等專業工具的手動復原方法，以及使用復原軟體的進階自動解決方案。Vasilii 的使命是讓 IT 專業人士和一般使用者都能獲得可靠的資料復原知識，協助他們保護寶貴的數位資產。.