Version History Issues

How to Recover a Missing or Deleted Worksheet in Excel for Mac

Bushra Parveen Oct 8, 2026 870 views

Question details

The user needs to recover a specific worksheet that is missing or was accidentally deleted from an Excel workbook.

How to Recover a Missing or Deleted Worksheet in Excel for Mac

Product: Microsoft Excel
Device & OS: Mac
Scenario: The user opens an existing workbook and notices one of the worksheets is missing, and Undo is no longer an option because the file has been saved.
Observed behavior: One worksheet is missing from the workbook while all other sheets remain present, and the deleted worksheet cannot be found in the Mac Trash.

Before you start

Before attempting advanced recovery methods, verify that you haven't simply scrolled the sheet tabs out of view at the bottom of the window, and ensure your Mac's Time Machine backup drive is connected if you rely on local backups.

Solution 1Recommended

Unhide a Hidden Worksheet

Check if the worksheet was accidentally hidden rather than permanently deleted.

Often, a worksheet is simply hidden from view and can be easily restored without needing to rely on backup files. This should always be your first troubleshooting step.

Right-click a visible tab

Right-click (or Control-click) any visible worksheet tab at the bottom of your Excel window.

Select the Unhide option

Choose 'Unhide' from the context menu. If this option is grayed out, there are no hidden sheets in your workbook.

Restore the missing sheet

In the Unhide dialog box, select the name of the missing worksheet and click 'OK' to make it visible again.

Quick Tip: You can hide or unhide multiple sheets at once in newer versions of Excel for Mac by holding the Command key while selecting sheets in the Unhide dialog.

Solution 2

Restore Using OneDrive Version History

If your file is synced to OneDrive, you can revert to a previous version saved before the sheet was deleted.

Solution 3

Recover using Mac Time Machine

For locally saved files, use your Mac's built-in Time Machine feature to retrieve an older backup of your workbook.

Free Microsoft Office alternative

Never Lose Your Work Again with WPS Office

Tired of complicated recovery processes? WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. With built-in WPS Cloud auto-sync and robust local backup features, you can easily track version history and recover deleted worksheets in seconds without relying on external backup drives.

1. Download and Install: Download WPS Office for free and install it on your Mac.
2. Open Excel Files Natively: Open your existing .xlsx workbooks directly in WPS Spreadsheet without any formatting loss.
3. Enable Auto-Backup: Turn on WPS Cloud sync to automatically maintain version history for effortless sheet recovery in the future.

100% compatible with Microsoft Excel (.xlsx) formatsBuilt-in document version history and intelligent auto-backupFree and lightweight suite for Mac, Windows, and mobileFamiliar user interface ensuring zero learning curve for migration

microsoft office alternative - wps office

Frequently Asked Questions

Can I recover a deleted worksheet using the Undo button?

You can only use the Undo shortcut (Command + Z) immediately after deleting the worksheet, provided you have not saved and closed the workbook. Once the file is saved and closed, the Undo history is cleared permanently.

Where do deleted Excel worksheets go on a Mac?

Unlike deleted standard files, deleted worksheets within an Excel workbook do not go to the Mac Trash. They are permanently removed from the file structure upon saving, which is why version history or Time Machine backups are required for recovery.

Why is the Unhide option grayed out in Excel?

If the Unhide option is grayed out when you right-click a worksheet tab, it means there are currently no hidden worksheets in that specific workbook. The missing sheet was either deleted or moved to an entirely different file.

Document & File Issues