You can watch a video tutorial here.
One of the basic rules of working with files on a computer is to always save your work. Everyone must have faced a situation where having done a lot of edits, the application suddenly closes and all the work is lost. Excel has an AutoRecover option that retains a version of the file if it is closed without saving. This version can be retrieved.
Step 1 – Open the Info box
– Go to File > Info
Step 2 – Choose the recover option
– Expand the Manage Workbooks dropdown
– Click Recover Unsaved Workbooks
Step 3 – Find the file
– Select the unsaved file
– Click Open
Step 4 – View the file
– Check that the file is the correct one
– Click Save As
Step 5 – Save the file
– Choose the folder
– Click Save