How To Enable or Disable AutoCorrect in Excel

Excel has many features designed to assist you with data entry. For example, AutoCorrect, by default, is enabled to correct typing errors. However, you have the option to enable and disable other types of corrections if you wish. For example, you can use AutoCorrect to fix misspelled words and capitalization errors as you type using pre-configured corrections.

In this article, we’ll show you how to enable and disable Excel’s AutoCorrect options. In addition, we’ll let you know how to add other words to AutoCorrect’s pre-configured corrections list.

How to Enable or Disable AutoCorrect in Excel on a PC

To enable or disable Excel’s AutoCorrect options, follow these steps via your PC:

1. Open the “Excel” app, and the spreadsheet you’re working in.
   
2. Click on “File” then select “Options.”
   
3. On the left side of the “Excel Options” window, choose “Proofing.”
   
4. Click the “AutoCorrect Options…” button.
   
   • In the “AutoCorrect Options…” dialog box, you’ll see a list of different types of corrections, e.g., “Replace text as you type.”
     
5. Click the box beside a correction type to enable it. You can check all the boxes if you wish. To disable a correction type, uncheck the box(es).
   
6. Click “Ok,” then “OK” again to save the changes and close the dialogs.
   

How to Enable or Disable AutoCorrect in Excel on an iPad

Follow the steps below to enable or disable AutoCorrect options using your iPad:

1. Open “Settings” and select “General”
   
2. Scroll down and tap “Keyboard”
   
3. Locate the Auto-Correction option
4. Swipe the button next to “Auto-Correction” to turn it off
   

How to Enable or Disable AutoCorrect in Excel on an iPhone

To enable or disable Excel’s automatic correction options, follow these steps on your iPhone:

1. Open “Settings” and select “General”
   
2. Scroll down and tap “Keyboard”
   
3. Locate the Auto-Correction option
4. Swipe the button next to “Auto-Correction” to turn it off.
   

How to Enable or Disable AutoCorrect in Excel on an Android

To enable or disable Excel’s AutoCorrect feature, follow these steps via your Android device:

1. Open the Settings menu on your phone or tablet and select Languages & Input.
   
2. Tap Virtual keyboard under Keyboard and input methods.
   
3. Select Android Keyboard.
   
4. Select Text correction.
5. Slide off the toggle next to Auto-correction.
   

How to Enable or Disable AutoCorrect in Excel 365

Here’s how to enable or disable Excel’s automatic correction options in Excel 365:

1. Sign in to Microsoft Office 365.
   
2. Open the “Excel” app.
   
3. Open the spreadsheet you’re working in.
   
4. Choose “File” then “Options.”
   
5. On the left side of the “Excel Options” dialog, select “Proofing.”
   
6. Select “AutoCorrect Options….”
   
   • In the “AutoCorrect Options…” dialog box, there’ll be a list of different types of corrections, e.g., “Replace text as you type.”
7. Check the box beside a correction type to enable it. You can check all the boxes if you wish. Then uncheck the box(es) to disable the correction.
   
8. Click “Ok,” then “OK” again to save the changes and close the dialog windows.
   

Additional FAQs

How Do I Add My Own Words to Excel AutoCorrect?

Here’s how to add an AutoCorrect entry:

1. Open “Excel” and the spreadsheet you’re working in.

2. Select “File,” then “Options.”

3. In the “Excel Options” dialog box, choose “Proofing” on the left-hand panel.

4. Click the “AutoCorrect Options…” button.

5. In the “Replace” field, enter the text you want to be replaced e.g., “America.”

6. In the “With” field enter the correction, e.g., “America.”

7. Click “Add,” then “OK.”

8. Repeat the process to add additional words.

Excel AutoCorrects Your Mistakes

Excel’s AutoCorrect feature helps to keep your data error-free by correcting commonly misspelled words. In addition, it has a selection of other mistakes you can program to autocorrect, for example, accidental use of caps lock. At any time, you can add your own words and exceptions to the list and decide which correction types to enable or disable.

What other Excel features do you find useful for data entry support? Tell us in the comments section.

Related Posts

How To Turn Enable/Disable Two-Factor Authentication (2FA) for Gmail How to Enable or Disable Dark Mode for All the Major Google Apps How to Enable (or Disable) Two-factor Authentication on Facebook How to Turn Off AutoCorrect in Microsoft Word How to Turn Off AutoCorrect in Outlook How to Turn Off Autocorrect on a Samsung Phone How to Turn off Autocorrect on Mac How to Enable Cookies How To Convert Word to Excel