Retrieve deleted cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1542989%22%20slang%3D%22en-US%22%3ERetrieve%20deleted%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542989%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20my%20colleague%20accidentally%20deleted%20few%20columns%20in%20one%20of%20our%20sheets%20in%20the%20excel%20spreadsheet.%20We%20press%20undo%20until%20it%20says%20that%20there's%20no%20more%20undo%20action%20can%20be%20done.%20But%20the%20columns%20did%20not%20appear%20again.%20We%20don't%20have%20back-up%20of%20the%20previous%20data%20that%20were%20stored%20in%20the%20said%20columns%20or%20cells%20that%20were%20deleted.%20I%20hope%20you%20can%20help%20me%20in%20retrieving%20those%20cells.%20Thank%20you.%20Hoping%20for%20your%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1542989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1543438%22%20slang%3D%22de-DE%22%3ERe%3A%20Retrieve%20deleted%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1543438%22%20slang%3D%22de-DE%22%3Emaybe%20this%20information%20will%20help%20you...%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20To%20restore%20the%20unsaved%20version%2C%20open%20the%20file%20menu%20again%20by%20clicking%20on%20%22File%22%2C%20in%20which%20the%20version%20management%20is%20located%20in%20the%20%22Information%22%20area.%20Up%20to%20Excel%202010%2C%20all%20processing%20levels%20that%20were%20automatically%20saved%20and%20closed%20without%20saving%20are%20listed%20under%20%22versions%22.%20From%20Excel%202013%20to%20Excel%202019%2C%20you%20can%20find%20the%20options%20for%20recovery%20via%20the%20menu%20item%20%22Manage%20workbook%20%22Restore%20unsaved%20workbooks%22.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Restore%20from%20older%20versions%20%3CBR%20%2F%3E%20You%20can%20therefore%20specifically%20access%20an%20unsecured%20version%20of%20the%20Excel%20folder%20by%20simply%20clicking%20on%20the%20corresponding%20entry.%20As%20soon%20as%20this%20version%20is%20open%2C%20a%20message%20line%20above%20the%20table%20shows%20that%20it%20is%20an%20%22automatically%20saved%20version%22%20that%20was%20opened%20in%20read-only%20mode.%20%3CBR%20%2F%3E%20By%20clicking%20on%20%22Restore%22%20you%20can%20now%20replace%20the%20current%20version%20of%20the%20file.%20However%2C%20it%20is%20advisable%20to%20save%20the%20restored%20version%20with%20%22File%20%E2%9E%9E%20Save%20as%22%20under%20a%20modified%20file%20name%20-%20for%20example%2C%20with%20an%20attached%20version%20B%20-%20instead%20of%20overwriting%20the%20last%20saved%20version.%20Of%20course%2C%20this%20applies%20to%20all%20versions%20of%20Excel%20up%20to%20Excel%202019.%20%3CBR%20%2F%3E%20Folders%20not%20yet%20saved%20%3CBR%20%2F%3E%20even%20files%20that%20you%20have%20never%20saved%20can%20be%20restored%20in%20Excel%20if%20the%20folder%20was%20closed%20without%20being%20saved.%20To%20do%20this%2C%20start%20Excel%20and%20click%20on%20%22File's%20Open%20'Recently%20used'.%20The%20rescue%20is%20rather%20inconspicuous%20at%20the%20bottom%20right%20of%20the%20menu%3A%20%22Restore%20unsaved%20workbooks%22%20is%20the%20command%20that%20you%20now%20click%20to%20display%20the%20%22UnsavedFiles%22%20folder%20in%20the%20Excel%20open%20dialog%20box.%20Here%20you%20will%20find%20Excel%20folders%20that%20were%20not%20saved%20when%20you%20closed%20them.%20Select%20the%20file%20you%20are%20looking%20for%20and%20click%20on%20%22Open%22.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Restore%20unsecured%20Excel%20spreadsheets%20%3CBR%20%2F%3E%20Prerequisite%20for%20restoration%20In%20the%20event%20that%20you%20want%20to%20restore%20an%20%3CBR%20%2F%3E%20unsaved%20version%20of%20a%20workbook%2C%20it%20is%20necessary%20that%20your%20entries%20have%20been%20automatically%20saved%20by%20Excel%20while%20you%20are%20working.%20For%20the%20automatic%20backup%20to%20be%20active%2C%20the%20checkbox%20in%20front%20of%20%22Save%20AutoRecover%20information%22%20must%20be%20checked%20under%20%22File%20%E2%9E%9E%20Options%20%E2%9E%9E%20Save%22.%20In%20order%20to%20have%20the%20most%20current%20information%20possible%20when%20restoring%20Excel%20files%2C%20you%20should%20reduce%20the%20storage%20interval%20in%20the%20%22Minutes%22%20field%2C%20for%20example%20to%20%223%22.%20On%20the%20other%20hand%2C%20if%20you%20leave%20it%20at%20%2210%22%20minutes%2C%20it%20can%20happen%20that%20the%20last%20nine%20minutes%20of%20editing%20are%20missing%20when%20opening%20a%20restored%20version.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, my colleague accidentally deleted few columns in one of our sheets in the excel spreadsheet. We press undo until it says that there's no more undo action can be done. But the columns did not appear again. We don't have back-up of the previous data that were stored in the said columns or cells that were deleted. I hope you can help me in retrieving those cells. Thank you. Hoping for your response.

1 Reply
maybe this information will help you...

To restore the unsaved version, open the file menu again by clicking on "File", in which the version management is located in the "Information" area. Up to Excel 2010, all processing levels that were automatically saved and closed without saving are listed under "Versions". From Excel 2013 to Excel 2019, you can find the options for recovery via the menu item "Manage workbook \ Restore unsaved workbooks".

Restore from older versions
You can therefore specifically access an unsecured version of the Excel folder by simply clicking on the corresponding entry. As soon as this version is open, a message line above the table shows that it is an "automatically saved version" that was opened in read-only mode.
By clicking on "Restore" you can now replace the current version of the file. However, it is advisable to save the restored version with "File ➞ Save as" under a modified file name - for example, with an attached version B - instead of overwriting the last saved version. Of course, this applies to all versions of Excel up to Excel 2019.
Folders not yet saved
Even files that you have never saved can be restored in Excel if the folder was closed without being saved. To do this, start Excel and click on "File \ Open \ Recently used". The rescue is rather inconspicuous at the bottom right of the menu: "Restore unsaved workbooks" is the command that you now click to display the "UnsavedFiles" folder in the Excel open dialog box. Here you will find Excel folders that were not saved when you closed them. Select the file you are looking for and click on "Open".

Restore unsecured Excel spreadsheets
Prerequisite for restoration
In the event that you want to restore an unsaved version of a workbook, it is necessary that your entries have been automatically saved by Excel while you are working. For the automatic backup to be active, the checkbox in front of "Save AutoRecover information" must be checked under "File ➞ Options ➞ Save". In order to have the most current information possible when restoring Excel files, you should reduce the storage interval in the "Minutes" field, for example to "3". On the other hand, if you leave it at "10" minutes, it can happen that the last nine minutes of editing are missing when opening a restored version.

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)