How to Restore a Deleted Worksheet in Excel

by L.P. KlagesUpdated September 28, 2017
keyboard image by Fyerne from Fotolia.com

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.

Tips

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.

References

Photo Credits

About the Author

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.

More Articles

×