
read more that are available.īy default, the format would be “Excel Workbook (*xlsx).”, as this was used by most of the users.
For example, we can use the styles and format tab on the home tab to change the font of a cell or a table. Formatting can be done in a variety of ways.
We can select a specific format when we are saving our workbooks automatically by selecting the format from the list of excel formats Excel Formats Formatting is a useful feature in Excel that allows you to change the appearance of the data in a worksheet. We can also change the folder to save the backups by entering a different path into the “AutoRecover file location.” I request all to check for this autosave location in Excel options – Save. If you enable it and couldn’t able to save, then it will be stored in this path “ C:UsersaaAppDataRoamingMicrosoftExcel” (this path varies for everyone as their recoverĮxcel autosave location will be different. By default, Excel will take 10 minutes to perform AutoRecover, but we can change this time as per our requirement, such as 1,2,3 minutes. This is where we are notifying excel to save the workbook for every n minutes (n could be any number representing no-of minutes in time).
From this window, we can see the “Save AutoRecover information every _ minutes” is enabled.Click on the “Save” option – This will take us to customize the workbooks that are saved. Excel options will pop out with many options to manage as per our necessity.