Geekers - Very often we forget to save our work on a spreadsheet in Excel, so if unwanted things happen such as power outages, hangs, errors or other unexpected technical problems on our computers, the work we did earlier will be wasted. We sometimes forget and are too engrossed in saving manually (ctrl+S), especially when we are working on multiple worksheets, we even make mistakes when closing documents.
For the purpose of user convenience, Microsoft embeds a simple but important feature, namely automatic saving when a document is being edited. The presence of this feature helps users feel safe if something happens in the middle of a typing activity, such as a blackout, sudden death, or other unexpected disturbances.
By default, the autosave feature in Office programs is active every 10 minutes. But if we think that the time span is too long, we can rearrange the automatic saving to our liking. Then, how do you set the storage duration in Microsoft Excel automatically?
Well, this time I will share about how to set the saving duration in Microsoft Excel automatically very easily. how do? Just follow the steps below.
How to Automatically Set Storage Duration in Microsoft Excel
The method that I share this time is to use Microsoft Excel version 2013. However, if you use another version that's fine too, because the method used is almost the same as in other versions. Immediately, refer to the following steps.
1. First, please open your Microsoft Excel application first on your laptop / PC.
2. Then, please click “File� which is on your top left. As in the picture below.
How to Set Storage Duration in Microsoft Excel How to Set Storage Duration in Microsoft Excel
3. Then, please click "Options". As in the picture below.
click options click options
4. Then, please click "Save". As in the picture below.
How to Set Storage Duration in Microsoft Excel How to Set Storage Duration in Microsoft Excel
5. Then, please click the tick on “Save AutoRecover information every …. minutes”. Please set how many minutes you want to save your excel file. Then, please click "OK". As in the picture below.
enter the time enter the time
6. Done.
TIP: The amount of new information in the recovered file depends on how often the Microsoft Office program saves the recovered file. For example, if a recovery file is only saved every 15 minutes, the recovered file will not load your work in the last 14 minutes before a power outage or other problem occurred.
To be on the safe side, enter a small number in the minutes box, such as 5 or 10. That way, you won't miss more than 5 or 10 minutes of work.
RELATED TUTORIALS
* 2 Ways to Change the Date Format in Excel for Beginners
* Tutorial on How to Delete Blank Columns and Rows in Excel
* How to Delete Double Data (Duplicates) in Excel
* Tutorial on how to lock an Excel file with a password