How to recover deleted excel sheets

How to

Accidentally delete a worksheet in Excel? You can restore it. Here are the steps to undo and restore a deleted worksheet in Excel software.

Excel is one of the most popular software for creating solid data sheets. Many of us use Excel to create documents such as income statements, balance sheets, marketing budgets, calendars, and statistics. The good thing about Excel is that it has many features.On the other hand, it supports many built-in and custom Excel features.

As part of managing data in Excel, mistakes often occur. One such common mistake is deleting an entire worksheet in Excel. For example, one sheet was deleted instead of another, or the sheet names were mixed up, etc. Deleting a sheet in Excel for any reason will permanently delete that sheet from the file.

However, under two specific circumstances you can undo it, i.e., restore a deleted sheet in Excel . Once restored, you can save the file again and restore the data intact.

This quick and easy guide will show you how to restore a deleted sheet in Excel. The following steps will help you to restore a deleted sheet in Excel, and we hope you will find them useful.

Table Contents:

  • Restore deleted sheet in Excel

    Restore a deleted Excel worksheet

    After deleting an Excel worksheet. There are two specific options for recovering the file. One is before saving the file and the other is after saving the file. These two methods are described below. To recover a deleted Excel worksheet, follow the method according to the example usage.

    Before saving the Excel file

    If you have deleted a worksheet and have not yet saved the Excel file, you can restore a deleted Excel worksheet fairly quickly. This is because the changes have not yet been saved. Here is how to do it.

    1. First, close the Excel application.
    2. When prompted, click the “Don’t Save” button.
    3. Open the Excel file again.
    4. You should see the deleted worksheet in the Excel file.
    5. This completes the restoration of the deleted Excel worksheet.

    Detailed instructions:

    First, close the Excel application. You can do this by clicking on the “X” icon in the upper right corner. When prompted, click the “Do not save” button. This way, changes to the Excel file will not be saved.

    Next, locate and open the Excel file. If you deleted a worksheet and did not save the Excel file, the deleted worksheet will appear as soon as you open the Excel file.

    Now you have restored the deleted worksheet to Excel.

    After saving the Excel file

    If you saved the Excel file after deleting the worksheet, there is another way to restore the deleted worksheet, assuming you are using OneDrive to save and store your Excel file.

    Office 365

    If you are using Office 365, you use OneDrive to store your files. So, you can use the built in option to restore a deleted Excel worksheet. Below are the instructions on how to do this.

    1. Open the Excel file.
    2. Click on the “File” option.
    3. Go to the “Information” tab.
    4. Click on “Version History”.
    5. Select the version and it will appear in a new window.
    6. If you have deleted sheets in that version, click the “Restore” button.
    7. If not, try opening other versions until you find the deleted worksheet.
    8. Once restored, save the Excel file.
    9. This completes the restoration of the deleted Excel worksheet.

    If you are using Office 2016 – 2019

    Office 2019 or earlier, you can still restore a deleted worksheet if you have saved your Excel file using OneDrive.

    First, access OneDrive from the link below. You can also search using Google or Bing. When asked to sign in, authenticate your Microsoft account and sign in.

    https://onedrive.com/ or https://onedrive.live.com/

    Search for an Excel file in your OneDrive account. Then select the file.

    Once you have selected the file, click the Version History option on the top bar.

    Once you do this, OneDrive will open the Excel file in a new tab and the older version will appear in the sidebar. Scroll through each older version until you find the deleted worksheet.

    When you find the version you are looking for, click the “Restore” or “Download” link below the version in the sidebar.

    That’s it. You have now restored or recovered a deleted Excel worksheet using OneDrive.

    IMPORTANT NOTE: If you have not saved the Excel file using OneDrive, and you have already saved the Excel file after deleting the worksheet, there is no way to recover a deleted worksheet in this situation.

    Thus, it is very easy to restore a deleted sheet in Excel.

    I hope these simple instructions for using Excel will help you.

    If you are having trouble or need help, please send me an email and I will do my best to help.<1

    YouTube video: How to Recover Deleted Excel Sheets


Rate article
We provide high-quality and detailed Windows tutorials