Microsoft Excel: Add the AutoSave Toggle to the Quick Access Toolbar
Question details
The user needs to find or restore the AutoSave toggle in the latest version of Microsoft Excel or another Microsoft application.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to control AutoSave but cannot find the command in the Excel interface.
- Observed behavior
- The AutoSave toggle is missing from the toolbar or ribbon.
Check whether the workbook is saved in OneDrive or SharePoint and confirm that you are signed in to the account associated with the file. AutoSave availability can vary by application, account, file location, and subscription.
Add Turn AutoSave On/Off to the Quick Access Toolbar
Use this method when the AutoSave toggle is missing from the Excel ribbon or standard toolbar.
Microsoft Excel lets you add commands that are not currently displayed to the Quick Access Toolbar. The AutoSave command may still be available even when the toggle is hidden, although its functionality depends on the application, account, and workbook location.
In Microsoft Excel, right-click the Quick Access Toolbar near the top of the window and select Customize Quick Access Toolbar. You can also open File > Options > Quick Access Toolbar.
In the Excel Options window, open the Choose commands from drop-down menu and select All Commands.
Scroll through the command list or click inside it and type to locate Turn AutoSave On/Off.
Select Turn AutoSave On/Off, click Add, and then select OK to apply the toolbar change.
Return to the workbook and select the new AutoSave button on the Quick Access Toolbar. If it remains unavailable, check the file location, account sign-in, and Excel version.
Use WPS Office for familiar document and spreadsheet workflows
If you need a lightweight alternative to Microsoft Excel, WPS Office provides a familiar interface, broad Microsoft Office format compatibility, and convenient spreadsheet editing without changing your existing workflow. Open or migrate Excel workbooks in WPS Spreadsheet and continue working with common .xlsx files.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the WPS Office home screen.
- 2. Open an Excel workbook: Select Open from the home screen and choose an existing .xlsx or .xls file from your computer or cloud storage.
- 3. Continue editing in WPS Spreadsheet: Use the spreadsheet editing tools and save the workbook in its original Excel-compatible format when needed.
Frequently Asked Questions
Why is the AutoSave toggle missing in Microsoft Excel?
AutoSave visibility and availability can depend on the Excel version, signed-in account, workbook format, and storage location. It is commonly available for files saved in OneDrive or SharePoint.
Where can I find Turn AutoSave On/Off in Excel?
Right-click the Quick Access Toolbar, choose Customize Quick Access Toolbar, set Choose commands from to All Commands, select Turn AutoSave On/Off, click Add, and select OK.
Can I use AutoSave for a workbook stored only on my computer?
Microsoft AutoSave generally depends on cloud storage such as OneDrive or SharePoint. A locally stored workbook may not support the same AutoSave behavior, even after the command is added.
Does adding the command enable AutoSave in every Microsoft application?
No. The command and its behavior depend on the specific Microsoft application, account, file type, and storage location. Repeat the customization in each application where needed.
