➤ How to enable or disable AutoCorrect in Excel 🕹

In this article, we will show you how to enable and disable Excel's autocorrect options. Additionally, we'll show you how to add more words to the autocorrect pre-configured corrections list.

Excel has many features designed to help you with data entry. For example, automatic correction is enabled by default to correct typing errors. However, you have the option to enable and disable other types of fixes if you wish. For example, you can use AutoCorrect to correct misspelled words and capitalized errors as you type using preconfigured corrections.

How to enable or disable AutoCorrect in Excel on PC

To enable or disable Excel's autocorrect options, follow these steps via your PC:

Open the "Excel" app and the spreadsheet you are working on.
Click "File", then select "Options".
On the left side of the "Excel Options" window, choose "Proofing".
Click on the “AutoCorrect Options…” button.
- In the "AutoCorrect Options ..." dialog box, you will see a list of different types of corrections, such as "Replace text as you type".
Click the box next to a fix type to enable it. If you wish, you can check all the boxes. To disable a correction type, uncheck the boxes.
Click "Ok", then "OK" again to save the changes and close the dialogs.

How to Enable or Disable AutoCorrect in Excel on iPad

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

Launch the "Excel" app.
Open the worksheet you are working in.
Tap "File", then "Options".
Choose "Proofing" on the left side of the Options window.
Tap the "AutoCorrect Options ..." button.
- From the "AutoCorrect Options ..." dialog, you will see a list of various types of corrections, for example "Capitalize first letter of sentences".
Check the boxes next to a fix to enable it. Uncheck the boxes to disable the fix.
Tap "Ok", then "OK" again to save the changes and exit the dialogs.

How to enable or disable AutoCorrect in Excel on iPhone

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

Open "Excel", then the spreadsheet you are working on.
Select "File" and then "Options".
On the left side of the "Excel Options" dialog, select "Proofing".
Select "Auto Correction Options ..."
- In the "AutoCorrect Options ..." dialog box, the different types of corrections available will be listed, for example "Correct two uppercase initials".
Tap the boxes next to a fix type to enable it. Or, tap (uncheck) the boxes again to disable it.
Tap "Ok", then "OK" again to apply the changes.

How to enable or disable AutoCorrect in Excel on Android

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

Open the "Excel" app.
Access the spreadsheet you are working in.
Tap "File", then "Options".
Select "Proofing" from the left side of the "Excel Options" window.
Tap the "AutoCorrect Options ..." button.
- From the "AutoCorrect Options ..." dialog, you will see a list of different types of corrections, for example "Capitalize day names".
Check the box next to a correction type to enable it. Uncheck the boxes to disable the fix.
Tap "Ok", 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 autocorrect options in Excel 365:

Sign in to Microsoft Office 365.
Open the "Excel" app.
Open the worksheet you are working in.
Choose "File" and then "Options".
On the left side of the "Excel Options" dialog, select "Proofing".
Select "Auto Correction Options ..."
- In the "AutoCorrect Options ..." dialog, there will be a list of different types of corrections, for example "Replace text as you type".
Check the box next to a correction type to enable it. If you wish, you can check all the boxes. Then uncheck the boxes to disable the fix.
Click "Ok", then "OK" again to save the changes and close the dialogs.

Additional FAQs

How do I add my words to Excel autocorrect?

Here's how to add a custom entry in autocorrect:

Open "Excel" and the spreadsheet you are working on.
Select "File", then "Options".
In the "Excel Options" dialog, choose "Proofing" in the left panel.
Click on the “AutoCorrect Options…” button.
In the "Replace" field, enter the text you want to replace, for example "America".
In the "With" field enter the correction, eg. "America".
Click "Add", then "OK".
Repeat the process to add more words.

How to track changes in Microsoft Excel

Excel automatically corrects your mistakes

Excel's AutoCorrect feature helps keep your data error-free by automatically correcting misspelled words. Additionally, it has a selection of other errors that you can program for automatic correction, such as 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.