close
    search Buscar

    How to enable or disable AutoCorrect in Excel

    Who I am
    Judit Llordés
    @juditllordés

    Item Feedback:

    content warning

    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:

    1. Open the "Excel" app and the spreadsheet you are working on.
    2. Click "File", then select "Options".
    3. On the left side of the "Excel Options" window, choose "Proofing".
    4. 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".
    5. 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.
    6. 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:



    1. Launch the "Excel" app.
    2. Open the worksheet you are working in.
    3. Tap "File", then "Options".
    4. Choose "Proofing" on the left side of the Options window.
    5. 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".
    6. Check the boxes next to a fix to enable it. Uncheck the boxes to disable the fix.
    7. 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:


    1. Open "Excel", then the spreadsheet you are working on.
    2. Select "File" and then "Options".
    3. On the left side of the "Excel Options" dialog, select "Proofing".
    4. 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".
    5. Tap the boxes next to a fix type to enable it. Or, tap (uncheck) the boxes again to disable it.
    6. 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:

    1. Open the "Excel" app.
    2. Access the spreadsheet you are working in.
    3. Tap "File", then "Options".
    4. Select "Proofing" from the left side of the "Excel Options" window.
    5. 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".
    6. Check the box next to a correction type to enable it. Uncheck the boxes to disable the fix.
    7. 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:



    1. Sign in to Microsoft Office 365.
    2. Open the "Excel" app.
    3. Open the worksheet you are working in.
    4. Choose "File" and then "Options".
    5. On the left side of the "Excel Options" dialog, select "Proofing".
    6. 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".
    7. 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.
    8. 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:


    1. Open "Excel" and the spreadsheet you are working on.
    2. Select "File", then "Options".
    3. In the "Excel Options" dialog, choose "Proofing" in the left panel.
    4. Click on 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, eg. "America".
    7. Click "Add", then "OK".
    8. 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.


    Further Reading:

    • How to disable AutoCorrect on iPhone
    • How to activate automatic screen rotation on Xiaomi Mi 10T
    • How to activate automatic screen rotation on Xiaomi Mi 11
    • How to activate automatic screen rotation on Samsung Galaxy A52
    • How to activate automatic screen rotation on Samsung Galaxy A72
    add a comment from How to enable or disable AutoCorrect in Excel
    Comment sent successfully! We will review it in the next few hours.