How to Enable or Disable AutoCorrect in Excel

Excel has many features designed to help you enter data. 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 correct misspelled words and capitalization errors when typing using preconfigured corrections.

In this article, we are going to show you how to enable and disable Excel AutoCorrect options. Plus, we'll tell you how to add more words to AutoCorrect's list of preconfigured corrections.

How to Enable or Disable AutoCorrect in Excel on PC

To enable or disable Excel's AutoCorrect options, follow these steps through your PC:

1. Open the “Excel” application and the spreadsheet you are working in.
   
2. Click on “File” then select “Options”.
   
3. On the left side of the "Excel Options" window, choose "Verification".
   
4. Click the “AutoCorrect Options…” button.
   
   • In the “AutoCorrect Options…” dialog you will see a list of different types of corrections, for example, “Replace text as you type”.
     
5. Click the box next to a correction type to enable it. You can tick all the boxes if you wish. To disable a type of correction, uncheck the box(es).
   
6. Click "OK" and then "OK" again to save changes and close the dialog boxes.
   

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. Launch the “Excel” application.
2. Open the spreadsheet you are working in.
3. Press “File” then “Options”.
4. Choose "Verification" on the left side of the Options window.
5. Tap the “AutoCorrect Options…” button.
   • In the “AutoCorrect Options…” dialog box, there will be a list of different types of corrections, for example, “Capitalize the first letter of sentences”.
6. Check the box(es) next to a correction to enable it. Uncheck the box(es) to disable correction.
7. Press "Ok" and then "OK" again to save changes and exit the dialogs.

How to Enable or Disable AutoCorrect in Excel on an iPhone

To enable or disable Excel's AutoCorrect options, follow these steps on your iPhone:

1. Open "Excel", then the spreadsheet you are working on.
2. Select “File” then “Options”.
3. On the left side of the "Excel Options" dialog box, select "Verification".
4. Select “AutoCorrect Options…”.
   • In the “AutoCorrect Options…” dialog box, the different types of corrections available will be listed, for example, “Correct two initial capitals”.
5. Tap the box(es) next to a correction type to turn it on. Or, tap (uncheck) the box(es) again to turn it off.
6. Press "Ok" and then "OK" again to apply the changes.

How to Enable or Disable AutoCorrect in Excel on an Android

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

1. Open the “Excel” application.
2. Navigate to the spreadsheet you are working in.
3. Press “File” then “Options”.
4. Select "Verification" on the left side of the "Excel Options" window.
5. Tap the “AutoCorrect Options…” button.
   • In the “AutoCorrect Options…” dialog box, you will see a list of different types of corrections, for example, “Capitalize day names”.
6. Check the box next to a correction type to enable it. Uncheck the box(es) to disable correction.
7. Press "Ok" and then "OK" again to apply the changes and exit the dialogs.

How to Enable or Disable AutoCorrect in Excel 365

Here's how to enable or disable Excel's AutoCorrect options in Excel 365:

1. Sign in to Microsoft Office 365.
   
2. Open the “Excel” application.
   
3. Open the spreadsheet you are working in.
   
4. Choose “File” then “Options”.
   
5. On the left side of the "Excel Options" dialog box, select "Verification".
   
6. Select “AutoCorrect Options…”.
   
   • In the “AutoCorrect Options…” dialog box, there will be a list of different types of corrections, for example, “Replace text as you type. »
7. Check the box next to a correction type to enable it. You can tick all the boxes if you wish. Then uncheck the box(es) to disable the correction.
   
8. Click "Ok" and 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 are working in.

2. Select "File", then "Options".

3. In the "Excel Options" dialog box, choose "Verification" from the left panel.

4. Click the “AutoCorrect Options…” button.

5. In the "Replace" field, enter the text you want to replace, for example "America".

6. In the "With" field, enter the correction, for example "America".

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

8. Repeat the process to add additional words.

Excel automatically corrects your errors

Excel's AutoCorrect feature helps keep your data error-free by correcting commonly misspelled words. Additionally, it offers a selection of other errors that you can program to fix automatically, for example, accidental use of caps lock. At any time, you can add your own words and exceptions to the list and decide which types of corrections to enable or disable.

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