Share via

how to get delete excel sheet 1 tab recovery

Anonymous
2021-08-12T07:55:27+00:00

how to get delete excel sheet 1 tab recovery

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-08-12T11:54:55+00:00

    Hello Patel Jalpesh,

    Sorry to hear the inconvenience caused at your end. As per your description, I learn that you want to recover a deleted Excel tab (correct me if I am wrong). To do this, there two things to take into consideration mentioned below:

    Recover Deleted Worksheet in Excel Before Saving:

    When you delete a sheet in Excel, there is no Undo option for you. The easiest way to get it back is to close your workbook without saving the changes and then reopen it. The removed worksheet will be there again. But what if you have made many crucial changes to your workbook and you don't want to lose them? How to recover? Here is a solution. 

    1. Go to "File” and click "Save As" to save your working Excel document with a different filename.
    2. Re-open your original Excel document.
    3. Copy the deleted worksheet from the original file to the new renamed document.

    This method will help you restore deleted worksheet data to the new renamed Excel document and keep all the changes you have made to the Excel.

    Recover Deleted Worksheet in Excel after Saving:

    If you have saved your working Excel document, the original files will be overwritten, and there is nowhere you can open it to restore the deleted worksheet. In this case, you can try to recover the original Excel document via the Previous Version.

    1. Press Windows + E to open File Explorer and then open the folder that used to save the Excel document.
    2. Click the Excel file, click the "Home" tab on the toolbar and then click the "History" button in the Open group. It will tell File History to display all the files contained in the most recent backup of that folder. 
    3. Click the "Previous" button to locate and choose the version to recover. Then click the green "Restore" button to un-deleted the Excel worksheet. 

    Hope this helps and feel free to post back in this community.

    Best,
    Christophe

    60+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2021-08-12T08:02:31+00:00

    Looks like the problem may need a detailed problem statement.

    In general, you can delete a sheet by right click on its sheet name down below > Delete

    There are many shortcuts also to delete. ALT+E+L is the shortest one.

    Minimum one sheet is mandatory in an Excel workbook. Hence, if you have only one sheet, you will not be able to delete it.

    Edit - In case, you are talking about recovering a deleted worksheet, it won't be possible if you have closed the file and accepted the changes to save.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-08-17T13:08:33+00:00

    Hello Patel Jalpesh,

    I am writing to follow up on this thread. Did our proposed workaround solve your problem? Feel free to let us know how it goes at your end.

    Best Regards,
    Christophe

    2 people found this answer helpful.
    0 comments