autosave excel 2016 quick access toolbar

The autosave option is only available for Office 365 users. From now on, the excel files will be automatically saved to OneDrive in real-time. Here, select the “AutoSave OneDrive and SharePoint online files by default on Excel” checkbox and then click on the “Ok” button. In the “Options” window, select the “Save” tab on the sidebar. From the File menu, select “Options” from the sidebar. After that, click on the “File” option on the Ribbon menu.

With that, autosave is fully enabled in Excel.įirst, open an Excel file of your choice.

Select the “AutoSave OneDrive and SharePoint online files by default on Excel” checkbox.

To turn on autosave in Excel, follow the steps given below. If you are using Excel 2031/2016/2019, etc., you will not see the autosave option. Important note: You should be using Office 365 to use Excel autosave feature. In this quick and simple Excel how-to guide, let me show you the steps to turn on autosave in Excel. All you have to do is enable autosave in Excel and it will do the saving for you. If you forgot to save the file, you might lose precious data in the event of an application or system crash.Īfter all these years, Microsoft finally implemented the AutoSave feature in the newest version of Excel. Though not a big deal for most, constantly pressing the Ctrl + S shortcut can be a pain in the back at times. Without an autosave feature, you have to remember to constantly save the file.

In fact, I’ve seen support treads dating as far back as a decade. Excel users have been asking for the autosave feature for a long time now. Hope I was able to help you with this info.As good and feature-rich as Excel is, there is one important feature missing for all these years. Reset the Quick Access Toolbar to the default settings Group the commands by adding a separator between the commandsĬustomize the Quick Access Toolbar by using the Options command Remove a command from the Quick Access ToolbarĬhange the order of the commands on the Quick Access Toolbar

What do you want to do?Īdd a command to the Quick Access ToolbarĪdd a command to the Quick Access Toolbar that isn’t on the ribbon You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar. The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab on the ribbon that is currently displayed.

Autosave excel 2016 quick access toolbar