We all make mistakes. We all have those moments in which we regret our actions. Unfortunately, when it comes to working with a spreadsheet in Excel, making a mistake can mean that a critical worksheet has been deleted. Fortunately, there are several ways to recover deleted worksheet in Excel. In this blog post, we will discuss the various methods that you can use to restore a deleted worksheet in Excel, including using the Undo command, using Excel’s AutoRecover feature, and even using a backup to restore a deleted worksheet. We will also provide step-by-step instructions for each of the recovery options. With this post, you will have everything you need to be able to recover your deleted worksheet from Excel and get back to work quickly.
- Check your Trash folder. …
- Open the Info tab of the File menu. …
- Find the Manage Versions tab. …
- Navigate to the Recover Unsaved Workbooks tab. …
- Find the file name and version of the worksheet you want to restore. …
- Restore the version you want. …
- Turn on auto-save. …
- Create backup files.
How to recover a deleted worksheet in Excel
You can take the following actions to restore an Excel worksheet that has been deleted:
1. Check your Trash folder
It can often be helpful to check your computer’s Trash folder first before beginning the process of recovering a deleted file in Excel. This is due to the fact that most files are moved to the Trash folder when they are deleted, and if you haven’t recently cleared your Trash folder, there’s a chance your file may still be there. You can access your computer’s main menu or menu bar at the bottom of the screen to check your Trash folder. Look for a folder marked “Trash” or an icon of a trash can there.
You can look through the files listed after opening the folder to see if your Excel worksheet is there. You can simply move the file from your trash folder to your desktop or another folder where you intend to store it if you discover it there.
2. Open the Info tab of the File menu
Open Excel and select the File menu to begin the file recovery process if you cannot locate your deleted worksheet in your Trash folder. To access a different menu of choices, select the Info tab from the File menu. Normally, the File menu is located at the top of the screen, but depending on the version of Excel and the type of computer you’re using, it might show up as a button in the top-left corner of the open Excel application’s window. In this case, the button is typically green in color.
3. Find the Manage Versions tab
The next step is to locate the Manage Versions tab on the Info tab of the File menu. When you click “save” on a document, this can direct you to a list of files with the various versions of each file that you create. The Manage Versions tab can be found and clicked to access a new command menu.
4. Navigate to the Recover Unsaved Workbooks tab
One of the available commands is probably “Recover Unsaved Workbooks” and is listed inside the Manage Versions window. This is the command you can use to review any deleted files that haven’t been saved, as well as any multiple versions of the same file. Once you locate this command, you can select it to display the files you might want to recover in a window.
5. Find the file name and version of the worksheet you want to restore
The Recover Unsaved Workbooks menu shows a list of files that you might have created in the past but not saved when it is open. The following step is to browse these file names in search of the workbook you wish to restore. If you’re trying to restore the file that you were most recently working on, Excel typically displays these files in chronological order according to the date and time when you create them, so you can start looking at the top of the list.
When you locate the workbook you’re trying to restore, click on it to view the various versions that are available.
6. Restore the version you want
You can choose the desired version of the file once you’ve located the one you want to recover. Each file you create might have multiple versions available, especially if you edit it frequently. It can be helpful to select the most recent version of the file when recovering an accidently deleted one so you can access the one with the most recent changes and information. When you find the worksheet version you want to restore, click on it to make it stand out.
Then, to restore the file, click the “Restore” button on the appearing yellow bar.
Why might you need to recover a deleted worksheet in Excel?
There are numerous situations where recovering a deleted Excel worksheet is necessary. One of the most frequent instances where a user needs to restore a file is when they mistakenly click the Delete button or move the incorrect file to the Trash folder while attempting to delete a different file. In the event that the Excel program crashes and all work that hasn’t been saved appears to have been lost, someone may also need to recover a deleted worksheet. Additionally, understanding how to recover these files in the event that your computer’s hardware or internet connection malfunctions can be useful.
Tips for preventing accidental worksheet deleting
You can use the following advice to make sure you save your work:
Turn on auto-save
Some versions of Excel offer a feature called Auto-Save. When a user stops typing, the Auto-Save feature enables the program to save without the user having to click a Save button. As multiple versions of each file are continuously saved as users work on them, this can lessen the likelihood that a file will be lost.
Create backup files
Making backup files is another way to stop yourself from inadvertently deleting your work. The simplest way to accomplish this might be to simply create two copies of each file as you work on it. You can accomplish this by first saving a workbook the standard way, then duplicating the file to produce two distinct copies of the same document.
Protect your files with a password
Adding a password to each of your files is another way to protect them. For instance, many people add permission settings to Excel files using third-party software so that each file requires a password in order to open, edit, and delete. This can be useful because it forces you to pay attention to what you’re doing and prevents you from accidentally deleting any files even if you’re the one accessing the file.
Please note that Indeed is not affiliated with any of the businesses mentioned in this article.
how to recover missing worksheets in excel
FAQ
Can you undelete worksheets?
Choose the appropriate Excel file from the menu bar, then click “Home” after selecting it. To review the various iterations and look for the most recent, choose “History.” Open the file. Once opened, select “Restore” to reopen the missing worksheet.
