Home » Internet » How To Reset Excel Settings To Default

Internet

How To Reset Excel Settings To Default

Geeksdigit Team

May 25, 2026

0 Views

SaveSavedRemoved 0

Microsoft Excel is one of the most widely used spreadsheet applications for personal, academic, and professional work. Over time, users often customize Excel settings to improve productivity, change appearance preferences, modify formulas, install add-ins, create custom toolbars, or adjust advanced options. While these customizations can be helpful, they can also cause unexpected problems. Excel may start crashing, running slowly, displaying unusual behavior, showing missing menu items, opening files incorrectly, or failing to load certain features.

When troubleshooting Excel issues, one of the most effective solutions is resetting Excel settings to their default state. Resetting Excel removes customized preferences and restores the application to the original configuration provided by Microsoft. This can help resolve startup problems, performance issues, ribbon customization errors, add-in conflicts, formatting problems, and many other common Excel-related concerns.

The good news is that you do not always need to uninstall and reinstall Microsoft Office to reset Excel. Windows provides several methods that allow you to restore default settings safely. Depending on the problem you are experiencing, you can reset Excel options, reset the Ribbon, remove add-ins, delete configuration files, repair Microsoft Office, or completely recreate Excel settings from scratch.

In this guide, you will learn multiple ways to reset Excel settings to default on Windows 11 and Windows 10. Each method is explained step by step in simple language so you can choose the solution that works best for your situation.

Method 1: Reset Excel Options Manually

Many Excel problems are caused by customized settings rather than damaged program files. Resetting options manually is often the easiest solution.

Excel allows users to modify dozens of settings including formulas, proofing, save options, display preferences, advanced editing settings, and more. If a specific setting is causing problems, restoring it to its original state may fix the issue immediately.

Open Microsoft Excel and click the File tab located in the upper-left corner.

Select Options from the menu.

The Excel Options window will appear.

Review the categories on the left side:

• General
• Formulas
• Proofing
• Save
• Language
• Advanced
• Customize Ribbon
• Quick Access Toolbar
• Add-ins
• Trust Center

Return modified settings to their original values wherever possible.

Click OK after making changes.

Restart Excel and verify whether the issue has been resolved.

This method is useful when Excel still opens normally and only certain features are behaving unexpectedly.

Method 2: Reset the Excel Ribbon to Default

Many users customize the Excel Ribbon by creating custom tabs, hiding commands, or rearranging menu items. Sometimes these changes can make it difficult to find commands or create interface problems.

Resetting the Ribbon restores the original Microsoft layout.

Open Excel.

Click File > Options.

Select Customize Ribbon.

Locate the Reset button near the bottom-right corner.

Click the drop-down menu.

Choose:

• Reset only selected Ribbon tab
• Reset all customizations

Select Reset all customizations.

Confirm the action when prompted.

Click OK.

Close and reopen Excel.

After restarting, all Ribbon modifications will be removed and the standard Excel interface will return.

This method is particularly helpful if menu tabs disappear or Ribbon commands are missing.

Method 3: Reset the Quick Access Toolbar

The Quick Access Toolbar stores shortcuts for frequently used commands. If the toolbar becomes cluttered or behaves incorrectly, resetting it may help.

Open Excel.

Go to:

File > Options > Quick Access Toolbar

Click the Reset button.

Choose:

• Reset only Quick Access Toolbar

Confirm the reset.

Click OK.

Restart Excel.

The toolbar will now display the default Microsoft commands.

Method 4: Start Excel in Safe Mode

Safe Mode disables custom settings, startup files, add-ins, and extensions temporarily. This helps determine whether customized settings are causing problems.

Press:

Windows + R

Type:

excel /safe

Click OK.

Excel will launch in Safe Mode.

Use Excel normally for a few minutes and check whether the issue remains.

If Excel works correctly in Safe Mode, the problem is likely related to:

• Add-ins
• Startup files
• Toolbar customizations
• User preferences
• Third-party extensions

You can then proceed with the following reset methods to identify and remove the problematic configuration.

Method 5: Disable Excel Add-ins

Add-ins frequently cause startup delays, crashes, freezing issues, and unexpected errors.

Removing or disabling add-ins can effectively reset part of Excel’s environment.

Open Excel.

Click:

File > Options > Add-ins

At the bottom of the window, locate the Manage menu.

Select:

COM Add-ins

Click Go.

Uncheck all enabled add-ins.

Click OK.

Return to:

Manage > Excel Add-ins

Click Go.

Disable all Excel add-ins.

Restart Excel.

If Excel starts working normally, re-enable add-ins one at a time to identify the problematic extension.

Common examples include:

• PDF add-ins
• Accounting tools
• Data import tools
• Reporting extensions
• Third-party productivity utilities

Method 6: Delete the Excel Registry Settings

One of the most effective ways to completely reset Excel settings is removing its registry configuration.

Important: The Windows Registry contains critical system settings. Creating a backup before making changes is recommended.

Press:

Windows + R

Type:

regedit

Press Enter.

Navigate to:

HKEY_CURRENT_USER\Software\Microsoft\Office

Expand the Office folder.

Open the folder matching your Office version.

Examples include:

• 16.0 (Microsoft 365 / Office 2021 / Office 2019 / Office 2016)

Expand:

Excel

Right-click the Excel key.

Select:

Export

Save a backup copy.

After creating a backup:

Right-click the Excel key again.

Choose:

Delete

Confirm deletion.

Close Registry Editor.

Restart your computer.

Launch Excel again.

Excel automatically creates a fresh registry configuration using default settings.

This method resets:

• Excel preferences
• Interface customizations
• Startup settings
• User options
• Toolbar settings
• Recent customization changes

It is one of the most powerful Excel reset techniques available.

Method 7: Rename the Excel Registry Key Instead of Deleting It

If you prefer a safer approach, rename the Excel registry key instead of deleting it.

Open Registry Editor.

Navigate to:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel

Right-click the Excel folder.

Select:

Rename

Change the name to:

Excel-Backup

Close Registry Editor.

Restart Excel.

Excel will create a brand-new default configuration automatically.

If needed, you can later restore your original settings by renaming the backup folder.

This approach provides the benefits of a full reset while allowing easy recovery.

Method 8: Delete the Excel XLSTART Folder Contents

Excel automatically loads files stored in the XLSTART folder whenever it launches.

Corrupted files in this location can affect Excel behavior.

Press:

Windows + R

Type:

%appdata%\Microsoft\Excel

Press Enter.

Locate the:

XLSTART

folder.

Open the folder.

Move existing files to another location.

Do not permanently delete them initially.

Restart Excel.

If Excel now works correctly, one of the startup files was causing the issue.

Typical files found here include:

• Personal macros
• Startup workbooks
• Templates
• Automation files

Removing these files restores a cleaner startup environment.

Method 9: Remove Personal Macro Workbook

The Personal Macro Workbook stores recorded macros that load automatically when Excel starts.

Corruption in this file can create startup errors.

Navigate to:

%appdata%\Microsoft\Excel\XLSTART

Locate:

PERSONAL.XLSB

Rename it to:

PERSONAL-OLD.XLSB

Restart Excel.

Excel will create a fresh environment without loading the old macro workbook.

If the issue disappears, the macro workbook was likely responsible.

Method 10: Reset Default Excel Templates

Custom templates may alter workbook appearance and behavior every time Excel starts.

Resetting templates can restore default workbook settings.

Open File Explorer.

Navigate to:

%appdata%\Microsoft\Templates

Look for files such as:

Book.xltx
Sheet.xltx

Rename them:

Book-Backup.xltx
Sheet-Backup.xltx

Restart Excel.

Excel will recreate standard workbook templates automatically.

Default workbook settings will be restored.

Method 11: Clear Excel Cache Files

Temporary cache files occasionally become corrupted and cause unusual behavior.

Close Excel completely.

Press:

Windows + R

Type:

%temp%

Press Enter.

Select temporary files.

Delete unnecessary items.

You may skip files currently in use.

Next, open:

C:\Users\YourUsername\AppData\Local\Microsoft\Office

Remove temporary cache data if present.

Restart Windows.

Launch Excel again.

Many performance and loading issues can be resolved simply by clearing cached files.

Method 12: Reset File Associations for Excel

Incorrect file associations can prevent Excel files from opening properly.

Open Windows Settings.

Navigate to:

Apps > Default Apps

Search for:

Excel

Open file association settings.

Assign Microsoft Excel as the default application for:

• XLS
• XLSX
• XLSM
• CSV
• XLTX

Save changes.

Restart the computer.

This restores normal workbook opening behavior.

Method 13: Repair Microsoft Office

Office includes a built-in repair feature that can restore default settings and replace damaged program files.

Open:

Settings > Apps > Installed Apps

Locate Microsoft Office or Microsoft 365.

Click:

Modify

Select:

Quick Repair

Click Repair.

Wait for completion.

Test Excel.

If problems continue:

Repeat the process.

Choose:

Online Repair

Click Repair.

Online Repair performs a deeper reset and reinstalls Office components from Microsoft servers.

This often resolves serious Excel issues without affecting documents.

Method 14: Create a New Windows User Profile

Sometimes Excel problems originate from a damaged Windows profile rather than Excel itself.

Create a new user account.

Open:

Settings > Accounts > Other Users

Select:

Add Account

Create a new local or Microsoft account.

Sign into the new account.

Launch Excel.

If Excel works normally in the new profile, the issue likely involves corrupted user-specific settings.

You can continue using the new account or migrate files from the old profile.

Method 15: Completely Reinstall Microsoft Excel

If every other reset method fails, reinstalling Office provides the most thorough solution.

Open:

Settings > Apps > Installed Apps

Locate Microsoft Office.

Select:

Uninstall

Complete the removal process.

Restart Windows.

Download Office again from your Microsoft account.

Install Microsoft Office.

Open Excel.

Sign in with your Microsoft account if required.

Excel will load with completely fresh settings and configuration files.

This method resolves:

• Corrupted installations
• Missing components
• Damaged program files
• Severe startup issues
• Persistent crashes

Common Problems Fixed By Resetting Excel

Resetting Excel often resolves a wide variety of issues, including:

• Excel crashes on startup
• Excel freezes frequently
• Missing Ribbon commands
• Slow workbook loading
• Add-in conflicts
• Formula calculation issues
• Corrupted preferences
• Startup errors
• Macro loading problems
• Workbook template issues
• Display abnormalities
• Printing problems
• File opening errors
• Unexpected formatting behavior
• Broken Quick Access Toolbar settings

If Excel behaves differently than expected after customization, restoring default settings is often the quickest solution.

What Happens When You Reset Excel?

Many users worry about losing important spreadsheets after resetting Excel.

Generally, resetting Excel does not delete personal workbook files.

Your documents remain intact unless you manually remove them.

However, the following items may be reset:

• Ribbon customizations
• Quick Access Toolbar settings
• Excel preferences
• Add-in configurations
• Startup settings
• Macro settings
• Default templates
• Interface customizations
• Registry-based preferences

Items usually not affected include:

• Excel workbooks
• Saved spreadsheets
• Documents
• Data files
• OneDrive files
• Shared workbooks

Creating backups before major changes is still recommended.

FAQs

How do I restore Excel to factory settings?

The easiest way is to delete or rename the Excel registry key located under:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel

When Excel starts again, it automatically creates fresh default settings.

Will resetting Excel delete my spreadsheets?

No. Resetting Excel settings normally affects only preferences, toolbars, add-ins, and configuration files. Your workbook files remain unchanged.

How do I reset the Excel Ribbon?

Open:

File > Options > Customize Ribbon

Click:

Reset > Reset All Customizations

Then restart Excel.

What is the safest way to reset Excel?

Renaming the Excel registry key rather than deleting it is generally the safest approach because it allows easy restoration if needed.

Can I reset Excel without reinstalling Microsoft Office?

Yes. Most Excel issues can be fixed through settings resets, add-in removal, template resets, registry cleanup, or Office repair tools without reinstalling Office.

Why does Excel keep crashing after customization?

Custom add-ins, damaged templates, corrupted registry settings, startup files, or incompatible extensions are common causes. Resetting Excel often resolves these problems.

Does Office Repair reset Excel settings?

Office Repair mainly fixes damaged program files. Some settings may be refreshed, but a full reset usually requires removing Excel configuration data manually.

How do I remove all Excel add-ins?

Go to:

File > Options > Add-ins

Open both Excel Add-ins and COM Add-ins management windows and disable all installed add-ins.

Final Thoughts

Knowing how to reset Excel settings to default can save a tremendous amount of troubleshooting time. Whether Excel is crashing, freezing, displaying missing menu options, loading slowly, or behaving unpredictably, restoring the original configuration often resolves the issue quickly. Microsoft provides several ways to accomplish this, ranging from simple Ribbon resets to complete registry resets and Office repairs.

For most users, starting with basic solutions such as resetting the Ribbon, disabling add-ins, and clearing startup files is the best approach. If those methods do not solve the problem, deleting or renaming the Excel registry key can provide a complete settings reset without affecting your spreadsheets. More serious problems may require Office Repair or a full reinstallation of Microsoft Excel.

The key advantage of resetting Excel is that it restores stability while preserving your workbook files and important data. By following the methods explained in this guide, you can safely return Excel to its default state and eliminate many common problems that interfere with productivity. Whether you are a casual home user or a business professional, these reset techniques provide reliable ways to get Excel working properly again.