To reset Excel to its default settings, you can clear the Excel options, reset the ribbon and Quick Access Toolbar, and delete the Excel registry keys or app data folders that store customization. This guide walks you through each method, what it does, and how to avoid losing your work.
What “Default Settings” Means in Excel
Excel stores your preferences in two places: the options you set in the File > Options dialog (like formula calculation mode, default font, and save format) and the customization files that control the ribbon, Quick Access Toolbar, and add-ins. When people say “reset Excel,” they usually mean restoring all of these to the state Excel was in when first installed. This is different from resetting a worksheet (clearing cells and formatting) or repairing the program itself. Knowing which part you want to reset helps you choose the right method below.
Method 1: Reset Excel Options (Quickest)
If you just want to restore the main settings—like the default font, number of sheets, or calculation mode—you can do it manually without touching any files. Go to File > Options and adjust the most common settings:
- General: Set the default font (usually Calibri 11) and the number of sheets in a new workbook (usually 1).
- Formulas: Set calculation to “Automatic” and uncheck any weird iterative or precision options.
- Save: Choose the default file format (usually .xlsx) and set AutoRecover intervals.
- Advanced: Scroll through and reset things like “After pressing Enter, move selection” (usually Down) and “Show this number of recent workbooks” (usually 50).
This method is safe and doesn’t affect any of your files or add-ins. It’s the best first step if you only notice a few things are off.
Method 2: Reset the Ribbon and Quick Access Toolbar
The ribbon and Quick Access Toolbar (QAT) are customized through XML files, and there’s no built-in “reset all” button for them. To reset them to their default state, you need to delete the customization files that Excel creates. These files are stored in your user profile folder. The exact location varies by Excel version and operating system, but it’s usually under:
- Windows:
%APPDATA%\Microsoft\Excel\– look for files likeExcel.officeUI(for ribbon/QAT) andExcel15.xlb(for toolbar settings). - Mac:
~/Library/Group Containers/UBF8T346G9.Office/User Content/– look for a file calledExcel Customizations.
Close Excel completely, then delete those files. The next time you open Excel, it will recreate them with default settings. This does not affect your workbooks or any data—only the interface customization.
Method 3: Reset All Excel Settings via Registry (Advanced)
If you want a full reset—including all options, recent file lists, and some add-in states—you can delete the Excel registry keys. This is more aggressive and should be done with caution. The registry keys for Excel are under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (the “16.0” may be different for older versions like 15.0 for Office 2013).
- Close Excel and all Office apps.
- Press Win + R, type
regedit, and press Enter. - Navigate to the Excel key as above.
- Right-click the Excel key and choose Export to back it up (just in case).
- Delete the Excel key.
- Restart Excel. It will create a fresh key with default settings.
This method resets almost everything, including the list of recently opened files and some add-in registrations. It does not affect your actual workbook files, but it may remove some custom add-ins from the list (you can re-add them later). If you’re not comfortable editing the registry, skip this and use the file deletion method instead.
What About Resetting a Worksheet or Workbook?
A common confusion: “reset Excel” sometimes means clearing a worksheet to look like new. That’s a different task. To clear all data and formatting from a sheet, select all cells (Ctrl+A), then go to Home > Clear > Clear All. This removes values, formulas, and formatting but leaves the sheet structure intact. To reset a workbook to a blank state, you can simply create a new workbook (File > New > Blank workbook). There’s no built-in “factory reset” for a single workbook, but these manual methods achieve the same result.
Common Problems and Mistakes to Avoid
When resetting Excel, people often make these mistakes:
- Not closing Excel first: If Excel is running, it will overwrite your changes when you delete files or registry keys. Always fully exit (check the system tray for background processes).
- Deleting the wrong folder: The
%APPDATA%\Microsoft\Excelfolder also contains your personal macro workbook (PERSONAL.XLSB) and some add-in files. If you delete the whole folder, you’ll lose those. Only delete the specific customization files mentioned above. - Assuming it will fix a broken Excel: If Excel crashes or won’t open, a settings reset may not help. That’s usually a problem with the installation, and you should use “Quick Repair” or “Online Repair” from Control Panel > Programs > Programs and Features (select Office, then Change).
- Not backing up: Before deleting registry keys or files, export or copy them somewhere safe. It takes seconds and can save you from losing customizations you actually wanted.
Frequently Asked Questions
Will resetting Excel delete my files?
No. Resetting settings only affects the configuration, not your saved workbooks. Your .xlsx files remain untouched. However, if you delete the entire Excel app data folder, you might lose your personal macro workbook (PERSONAL.XLSB) and any custom dictionaries, so be selective.
How do I reset Excel to default without losing my add-ins?
If you want to keep add-ins, don’t delete the registry key or the whole app data folder. Instead, manually reset the options and ribbon as described in Methods 1 and 2. Add-ins are usually stored in separate folders, but some register in the registry, so a full reset will remove them from the list. You can re-enable them later via File > Options > Add-Ins.
Why is my Excel not showing the default font even after reset?
If you reset the font in Options but it still shows a different font, check if you have a template called “Book.xltx” in your XLSTART folder (usually %APPDATA%\Microsoft\Excel\XLSTART). That template overrides the default font and other settings. Delete or rename it to restore the true default.
Is there a command-line switch to reset Excel?
Excel doesn’t have a built-in “/reset” switch like some other Office apps. The closest is the /safe switch, which starts Excel in Safe Mode and disables add-ins, but it doesn’t reset settings. For a full reset, you must use the methods above.
How often should I reset Excel?
Only when you need to. If Excel is working fine, there’s no reason to reset. Frequent resets can be a sign that you’re making too many customizations that you later regret, or that you’re trying to fix a deeper problem. Try a repair first if you’re experiencing crashes or errors.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Google Photos Backup Stuck? Fixes That Work
- Record Your Own Alarm Sound on Android
- Transfer Music from ZTE to iPhone: Full Guide
- Angel Investor vs Venture Capitalist: Key Differences
- Sync Apps Between Android Devices Using Google Play
- Find What Drains Your iPhone Battery Fast