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 notice | Most likely cause | Where to fix it |
|---|---|---|
| Tabs, buttons or the Quick Access Toolbar look different | Ribbon customizations | Reset the ribbon |
| Excel is slow, crashes or shows extra tabs after installing something | An add-in | Safe Mode, then the Add-ins page |
| Every new workbook opens with odd fonts, columns or sheets | A custom Book template in XLStart | Remove the template |
| Workbooks open automatically at startup | XLStart or an alternate startup folder | Advanced options and Trust Center |
| Calculation, Enter key direction or gridlines behave differently | An option in Excel Options | Change it back by hand |
| Excel won’t start or errors persist in Safe Mode | Damaged program files | Repair Office |
Back Up Before You Reset Anything
A reset can’t be undone with Ctrl+Z, so save what you might want back.
- Go to File > Options > Customize Ribbon.
- Click Import/Export > Export all customizations and save the file somewhere you’ll find it.
- 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
- Right-click an empty area of the ribbon and choose Customize the Ribbon (or go to File > Options > Customize Ribbon).
- Click Reset below the right-hand list.
- 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.
- 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.

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.

- Close Excel.
- 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 /safeand press Enter. - Try the task that was failing.
- 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
- Open Excel normally and go to File > Options > Add-ins.
- At the bottom, open the Manage list and choose COM Add-ins, then click Go.
- 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.
- Restart Excel and check whether the problem is gone. Repeat for the next add-in if not.
- 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.

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.
- Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations to see the path of the XLStart folder.
- Close Excel and open that folder in File Explorer.
- Move any Book or Sheet template, and any workbook you don’t expect to open at startup, to your backup folder.
- Check File > Options > Advanced > General > “At startup, open all files in” for a second folder and clear it out the same way.
- 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.

- Close all Office apps.
- 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.
- Windows 10: right-click the Start button, choose Apps and Features, select Microsoft 365 or Office, then choose Modify.
- Pick Quick Repair first. It is faster and only finds and replaces corrupted files.
- 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.
- Quit all Office apps.
- In Finder, hold Option and choose Go > Library.
- Open Preferences and look for com.microsoft.Excel.plist. Drag it to the desktop.
- Open Excel and test. If the problem is gone, you can trash the file; if not, put it back.
- 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.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.