How to Restore a Deleted Worksheet in Excel
By L.P. Klages
Updated September 28, 2017
If you have ever accidentally deleted an Excel worksheet, it might seem like there's no way to make it reappear. After all, there's no "Undo" button on the ribbon (the top toolbar). One option is to close the workbook without saving: if you haven't made many changes, it might be possible to recover the document. If that doesn't work, you can still recover the file using a little known Microsoft Office trick.
Click “File > Save As…” to save your workbook with a different file name.
Click “File > Open” and select your original workbook, that still contains the deleted worksheet.
Right-click the sheet you want to get back, and choose “Move or Copy…”
Select your newer workbook with the missing sheet from the drop-down list labeled “To book.”
Press “OK.” Your newer workbook now has the recovered worksheet in it.
If you want to keep the worksheet in both the new and the old versions of the workbook, then make sure to check the "Create a copy" checkbox in the Move or Copy dialog box.
L.P. Klages is an entrepreneur and software developer, concentrating on information theory, software user experience, and mathematical modeling. He has been writing about technology and the business of technology since 1999. His articles have appeared on many sites, including GameDev.net, KenSharpe.net, and eHow. Klages attended Jacksonville University in Jacksonville, Fla.