How to Reset Excel to Default Settings

Excel has no single reset button. Reset the ribbon in File > Options > Customize Ribbon, test in Safe Mode, turn off add-ins, remove a startup template, and repair Office if needed.

Excel looks or behaves differently than it used to: the ribbon has changed, a setting you cannot find is causing trouble, or an add-in seems to have taken over, and you want it back the way it came. This covers desktop Excel for Microsoft 365 on Windows, plus Mac.

What “Default” Covers in Excel

Excel keeps its settings in several separate places, and each one is reset a different way. Microsoft’s Reset command on the Customize Ribbon page touches only the ribbon and the Quick Access Toolbar. Your workbooks are never changed by any of the steps below, except that a startup template you choose to remove stops being used for new files.

What you noticeMost likely causeWhere to fix it
Tabs, buttons or the Quick Access Toolbar look differentRibbon customizationsReset the ribbon
Excel is slow, crashes or shows extra tabs after installing somethingAn add-inSafe Mode, then the Add-ins page
Every new workbook opens with odd fonts, columns or sheetsA custom Book template in XLStartRemove the template
Workbooks open automatically at startupXLStart or an alternate startup folderAdvanced options and Trust Center
Calculation, Enter key direction or gridlines behave differentlyAn option in Excel OptionsChange it back by hand
Excel won’t start or errors persist in Safe ModeDamaged program filesRepair Office

Back Up Before You Reset Anything

A reset can’t be undone with Ctrl+Z, so save what you might want back.

  1. Go to File > Options > Customize Ribbon.
  2. Click Import/Export > Export all customizations and save the file somewhere you’ll find it.
  3. If you created a startup template or keep macros you rely on, copy those files to a backup folder before removing anything.

Later, Import/Export > Import customization file brings the exported ribbon back. Microsoft notes that importing replaces all existing ribbon and toolbar customizations, so treat it as a full swap.

Reset the Ribbon and Quick Access Toolbar

  1. Right-click an empty area of the ribbon and choose Customize the Ribbon (or go to File > Options > Customize Ribbon).
  2. Click Reset below the right-hand list.
  3. Choose Reset all customizations to return every tab and the Quick Access Toolbar to their default commands, or Reset only selected Ribbon tab to fix one built-in tab.
  4. Confirm and click OK.

Ribbon customizations are kept per Office app, so resetting Excel does not change Word or PowerPoint. This step does not reset fonts, calculation settings, add-ins or templates. If only the ribbon has vanished rather than changed, the problem is usually the display setting; the same idea is covered for Word in bringing back a missing toolbar.

Excel Customize Ribbon Reset menu
Reset all customizations covers the ribbon and Quick Access Toolbar only. (Recreated interface)

Change Excel Options Back by Hand

File > Options holds most of Excel’s behavior: the General, Formulas, Proofing, Save and Advanced pages. None of these pages has a reset control, so you have to put changed settings back one at a time. A few settings cause most of the confusion:

  • Formulas > Calculation options: set to Automatic if formulas stopped updating.
  • Advanced > Editing options: the direction the selection moves after you press Enter.
  • Advanced > General: the “At startup, open all files in” box. Clear it if unknown files open every time.
  • General: “Show the Start screen when this application starts” controls whether Excel opens to the Start screen or a blank workbook.
  • General: the default font and size for new workbooks. See changing the default font in Excel to set it back.

Bruno, an office manager, inherited a laptop where every new workbook opened in a large serif font with gridlines hidden. Resetting the ribbon did nothing because the cause was a Book template in the startup folder, covered below. Matching the symptom to the table above saves this kind of guessing.

Start Excel in Safe Mode

Safe Mode starts Excel without add-ins and without toolbar customizations, and it can’t save preferences or templates. If a problem disappears in Safe Mode, an add-in or a customization is the likely cause. Nothing is reset permanently; Safe Mode is a test.

Excel Safe Mode confirmation prompt
Hold Ctrl while opening Excel to get this prompt. (Recreated interface)
  1. Close Excel.
  2. Hold Ctrl and open Excel from its shortcut, then click Yes when asked to start in Safe Mode. Or press Windows key + R, type excel /safe and press Enter.
  3. Try the task that was failing.
  4. To leave Safe Mode, close Excel and open it normally.

If Excel won’t open even in Safe Mode, skip to the repair section.

Turn Off Add-ins One at a Time

  1. Open Excel normally and go to File > Options > Add-ins.
  2. At the bottom, open the Manage list and choose COM Add-ins, then click Go.
  3. Clear the box next to one add-in and click OK. This unloads it but keeps it in the list. Remove deletes it from the list, so leave that for add-ins you are sure you don’t need.
  4. Restart Excel and check whether the problem is gone. Repeat for the next add-in if not.
  5. Repeat with Excel Add-ins in the Manage list (this list includes built-in add-ins such as Analysis ToolPak and Solver).

Also pick Disabled Items in the Manage list and click Go. Excel may have switched off an add-in after a crash, and you can enable it again there. On a work computer, some add-ins are installed by your IT department; ask before removing them.

Excel COM Add-ins dialog
Clear a box to unload an add-in without removing it. (Recreated interface)

Remove a Custom Default Template

Excel uses a template named Book saved in the XLStart folder (or in an alternate startup folder) as the pattern for every new workbook, and one named Sheet for new worksheets. Deleting or moving those files restores Excel’s built-in blank workbook.

  1. Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations to see the path of the XLStart folder.
  2. Close Excel and open that folder in File Explorer.
  3. Move any Book or Sheet template, and any workbook you don’t expect to open at startup, to your backup folder.
  4. Check File > Options > Advanced > General > “At startup, open all files in” for a second folder and clear it out the same way.
  5. Start Excel and create a new blank workbook to confirm it looks standard.

Holding Shift while Excel starts stops automatic macros from running, which helps if a startup file misbehaves before you can reach it.

Repair Office

Repair fixes damaged program files. It isn’t documented as a way to clear your settings, so do it when Excel crashes, won’t start, or misbehaves even in Safe Mode. If problems follow only your Windows account, testing Excel under a different user account can show whether the cause is your profile.

Office repair options Quick Repair and Online Repair
Try Quick Repair before Online Repair. (Recreated interface)
  1. Close all Office apps.
  2. Windows 11: open Settings > Apps > Installed apps (labels can vary slightly by version), find Microsoft 365 or Office, and choose Modify from the three dots menu next to it.
  3. Windows 10: right-click the Start button, choose Apps and Features, select Microsoft 365 or Office, then choose Modify.
  4. Pick Quick Repair first. It is faster and only finds and replaces corrupted files.
  5. If that doesn’t help, run it again and choose Online Repair > Repair, which takes longer. Restart if asked.

Microsoft’s Repair an Office application page has the full instructions for each install type.

Reset Excel on a Mac

On a Mac, ribbon customizations live in Excel > Preferences (Settings on newer macOS) > Ribbon & Toolbar. Excel for Mac also keeps preferences in files you can move. Microsoft’s troubleshooting articles on this are older, so check that the files exist on your Mac before acting, and move them rather than deleting them.

  1. Quit all Office apps.
  2. In Finder, hold Option and choose Go > Library.
  3. Open Preferences and look for com.microsoft.Excel.plist. Drag it to the desktop.
  4. Open Excel and test. If the problem is gone, you can trash the file; if not, put it back.
  5. For Excel 2016 for Mac and later, Microsoft’s troubleshooting article also points to Library > Group Containers > the folder ending in .Office > com.microsoft.officeprefs.plist.

Don’t remove the whole .Office folder: Microsoft warns that doing so resets every Office app back to first-run setup.

Last Resort: Reinstall, Not the Registry

Many sites tell you to delete Excel’s registry keys. Microsoft’s support pages don’t document that as a reset method, and a wrong deletion can affect other programs, so it isn’t included here. If repair fails, uninstall Office from Windows 11 and install it again from your Microsoft account. Note your version first with checking which Excel version you have.

Excel reset questions

Will any of this delete my spreadsheets?

No. Resetting the ribbon, turning off add-ins and repairing Office leave your workbook files alone. Only files you move out of XLStart change what opens at startup.

Does Safe Mode change my settings?

No. It only skips add-ins and customizations for that session. Close Excel and reopen it normally to get everything back.

Why do CSV files suddenly open in another program?

That is a Windows default-app setting, not an Excel option, so none of the resets above affect it. Follow making Excel the default for CSV files instead.

Can I reset Excel for the web?

These steps are for the desktop app. Excel for the web doesn’t use desktop add-ins, startup folders or the Windows repair tool, so a problem there usually comes from the browser or the file itself.

Begin with the symptom table, take the backup, and work down the list until Excel behaves.