See all How-To Articles

How to Recover a Deleted Sheet in Excel & Google Sheets

This tutorial demonstrates how to recover a deleted sheet in Excel.

recover deleted sheet 6

Recover a Deleted Sheet in Excel

Say you deleted a worksheet in the active workbook and now you want to restore it (here, Sheet 2).

recover deleted sheet 1

  1. As soon as you notice that you deleted the sheet, click the X to close the entire workbook.

recover deleted sheet 2

  1. In the pop-up window, click Don’t Save.

recover deleted sheet 4

  1. After this, go to the location where you originally saved your file and reopen it.

recover deleted sheet 5

When you open the workbook again the deleted sheet is back!

recover deleted sheet 1

Tips

  • The best time to use this method is immediately after you delete the sheet; if you make any changes to the workbook after deleting the sheet, they won’t be saved.
  • Try setting up AutoSave to avoid this issue.
  • If you accidentally delete an entire workbook, see How to Recover a Deleted File.
  • It’s also possible to recover a file you didn’t save.

See all How-To Articles