How to Restore a Deleted Worksheet in Excelby 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.