Discover How to Reset Excel to Default Settings Effortlessly

Want to restore changes to Microsoft Excel? This article describes several effective ways to reset Excel to default settings on Windows 10 systems.

Microsoft Excel is the most commonly used spreadsheet editor, which you can customize to better meet your personal needs. However, over time, you may want to undo these custom settings, and the easiest way to do this is to restore Excel to its default settings.

So how do I reset Excel to the default settings? You can accomplish this task by using the Windows Registry, Windows PowerShell, and reinstalling the Office suite. Details are as follows.

Reset Excel to default settings in Windows 10

Method 1: Reset Excel default settings through the registry

First, we will guide you on how to reset Excel by editing the Windows registry.

Step 1: Press Windows R key combination to open the run window. Then type regedit in the text box and press Enter .

Step 2: When you see the User Account Control window, select the Yes option to continue.

Step 3: In Registry Editor, navigate to the following location according to your version of Office:

• Excel 2016/2019: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel
• Excel 2013: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel
• Excel 2010: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

Step 4: In the left panel, right-click the Options key and click Delete from the context menu.

Step 5: In the Confirm Delete Key window, select the Yes option to complete this task.

Method 2: Use PowerShell to reset Excel default settings

PowerShell is a scripting language for automated system management that can perform many functions. Similarly, you can use it to reset Excel to default settings. The following are the main steps.

Step 1: Use the Windows Search box to open Windows PowerShell.

Step 2: In the command line window, type the following command according to your version of Office and press Enter :

• Excel 2016/2019: Remove-Item -Path HKCU:\Software\Microsoft\Office\16.0\Excel -Recurse
• Excel 2013: Remove-Item -Path HKCU:\Software\Microsoft\Office\15.0\Excel -Recurse
• Excel 2010: Remove-Item -Path HKCU:\Software\Microsoft\Office\14.0\Excel -Recurse

Step 3: Exit PowerShell and open the Excel file to check if the Office application has returned to its default state.

Method 3: Reinstall Office

The last way to restore Excel default settings is to reinstall Office.

The following article details how to reinstall different versions of Office on a Windows computer:

• How to download and install Office 2021 for PC/Mac
• How to download and install Office 2019 for Windows for free
• Microsoft/Office 365 Download/install/reinstall on Win 10/11

Further reading:

Sometimes, Office files may be lost due to accidental deletion, system crashes, or virus attacks. If you need to recover deleted Excel files, Word documents, PPTs, OneNote files, etc., you can use MiniTool Power Data Recovery. It is a professional recovery software, specializing in recovering Office files, pictures, videos, audio files, etc.

First, you can scan and preview files using the MiniTool Power Data Recovery free version and recover 1 GB of projects for free. Second, if you need to recover more than 1 GB of files, you can upgrade the free version to the premium version.

Summarize

This tutorial describes how to reset Excel to default settings through detailed steps. You can choose the preferred method to complete this task.

If you have any questions about MiniTool Power Data Recovery, feel free to email. We are ready to help.

The image format remains the same.

The above is the detailed content of Discover How to Reset Excel to Default Settings Effortlessly. For more information, please follow other related articles on the PHP Chinese website!