How to use AutoCorrect in Excel

- Written by Puneet

What is AutoCorrect in Excel?

Autocorrect is a handy feature in Excel that automatically corrects common spelling errors. It can also be customized to substitute specific text strings as you type. As the name suggests, its main purpose is to replace typing errors with the correct word meaning as specified by you.

It has many additional capabilities with which it can be used to:

  • Correct typo errors,
  • Capitalization errors,
  • Convert abbreviations to full text,
  • Add check marks,
  • Symbols,
  • Etc.

In this tutorial, you will learn the different options available in the AutoCorrect feature.

Select Only the Required AutoCorrect Options in Excel

AutoCorrect is the default enabled feature in Excel with all the available options. Still, you can choose and disable one or more options that you do not want to use as a part of the AutoCorrect feature, and for this, you need to do the following steps:

  1. First, go to the “File” tab in the ribbon and then click on “Options” and you will get the “Excel Options” dialog box opened.
    excel-options
  2. After that, click on “Proofing” from the left side panel and then click on “AutoCorrect Options”.
    autocorrect-option
  3. At this point, you will get the “AutoCorrect” dialog box opened with all the default options already selected.
  4. Under the “AutoCorrect” tab, unselect the option you do not want to use as a part of the AutoCorrect feature, and then click OK. The AutoCorrect feature will get enabled by excluding that option.
    autocorrect-dialog-box

AutoCorrect Tab Options

Many options are available in AutoCorrect, which are selected to be used with the AutoCorrect feature by default. Here, we have explained the definitions of those options so you can understand them.

  1. Correct two initial capitals: When enabled, this option auto-corrects the first two capital letters of the words. For example, if you write “MEssage,” it will auto-correct it as Message. But if you deselect this option, AutoCorrect will not correct the first two capital initial letters.
  2. Capitalize the first letter of sentences: This option, when enabled, auto capitalizes the first letter of every new sentence. For example, if you write “How are you guys. we are doing well”, it will auto-capitalize the letter “w” of we and make the sentence “How are you guys. We are doing well.
  3. Capitalize names of days: As the name suggests, this option, when enabled, auto-capitalizes the name of days you enter in Excel. For example, if you write “Sunday”, it will capitalize the letter “s” and make it “Sunday”.
  4. Correct accidental use of caps lock key: This option, when enabled, auto-corrects the accidentally written words using caps lock. For example, if you write “Sunday”, it auto-corrects this word to “Sunday”.
  5. Replace text as you type: This option is used to replace some shortcodes, text, or abbreviations into full text, replace some texts with symbols, and replace some misspelled words with the correct ones. Autocorrect already has the predefined list of text and words, which will get auto-replaced with the pre-defined results when we enter them in the spreadsheet. You can remove some pre-defined words from the list and can expand the list by adding more to that list.

AutoCorrect Exceptions

The AutoCorrect feature also has the option to set some exceptions. Under exceptions, you will find the predefined list, which you can expand by adding more exceptions or delete by removing any non-required exceptions.

  1. Under the AutoCorrect tab, click on the “Exceptions” button.
    autocorrect-exceptions
  2. Once you click on the “Exceptions” button, you will get the “AutoCorrect Exceptions” dialog box opened.
  3. Under the “First letter” tab, you will find the pre-defined list of exceptions as per which, after the dot (.)/period of specific letters or words, AutoCorrect will not make the first letter capital. This list you can expand or delete this based on your requirements.
    first-letter-tab
  4. Under the “Initial caps” tab, you can add the list of words where you don’t want AutoCorrect to check the first two capital letters of the words as it does when you select the “Capital two initial letters” options in AutoCorrect options, as mentioned above.
    initial-caps-tab

As you can see in the above screen capture, we have added “EXcelchamps” and IDs” within the list, which means from now onward, whenever we enter those two words in the spreadsheet, AutoCorrect will not change the second letter of the word into caps off as we have defined the exception for those two words.

AutoFormat as You Type Tab Options

The Autoformat tab consists of three by default selected auto-formatting options that are very helpful while working in Excel, which is explained below:

autoformat-as-you-type
  1. Internet and network path with hyperlinks:  You have always seen when you enter any hyperlink or web address in the spreadsheet, it gets converted as a hyperlink by clicking on which one can redirect to that link address. That all happens due to this option. Un-select this option if you do not want to convert those links to hyperlinks.
  2. New rows and columns in the table: You have always seen that when you enter any value in the adjacent column or row of the Excel table, the table will expand up to that row or column by including them in the table. This happens due to this option. If you disable it, the Excel table will not auto-expande anymore.
  3. Fill formulas in the table: This option auto-copies the formula you entered into all the down cells in the same column within the Excel table by adjusting the formula’s cell references.

Actions Tab

The action tab can create additional actions based on specific words, text, or values. The additional actions are disabled by default. To enable them, select the “Enable additional actions in right-click menu” option. Excel only has Date (XML) as a pre-defined additional action in the list, but you can create more as needed.

actions-tab

Once you enable this option, the date action will be enabled as it is pre-defined by Excel, which means that when you enter the date in the cell after this, it will be enabled.

If you right-click on it, Excel will show you the Outlook calendar options, which you will get routed to your calendar by clicking on. Outlook must be configured with the Email ID to pop up this additional calendar option.

Math AutoCorrect Tab

The math AutoCorrect tab is used to insert the mathematical symbols within the equations.

math-autocorrect-tab

This Math AutoCorrect function does not work in the cell. It works only in equations (Insert tab à symbols à equations)

Disable AutoCorrect Feature

Excel does not have any option to disable the AutoCorrect feature directly. To stop the AutoCorrect feature completely, users must un-select all the “AutoCorrect” and other tab options.

un-select-autocorrect-options
  • Open Excel Options: In the drop-down menu, click on ‘Options’. This will open the Excel Options dialog box.
  • Navigate to Proofing: In the Excel Options dialog box, find and click on ‘Proofing’ in the left-hand menu.
  • Open AutoCorrect Options: In the ‘Proofing’ tab, look for the ‘AutoCorrect Options’ button and click on it. This will open the AutoCorrect dialog box.
  • Disable AutoCorrect: The AutoCorrect dialog box shows a list of options with checkboxes next to them. To disable AutoCorrect, uncheck the box that says ‘Replace text as you type’.
  • Save Your Changes: Click ‘OK’ to save your changes. This will close the AutoCorrect dialog box and take you back to your spreadsheet.

Points to Consider

While using the AutoCorrect feature in Excel, here are some points to consider:

  • Unexpected Corrections: AutoCorrect can sometimes change text you didn’t intend to correct. It’s important to review any changes made by AutoCorrect to ensure they’re accurate.
  • Use of Symbols: AutoCorrect also replaces certain symbol combinations with special characters. If you frequently use these symbol combinations in your work, you may want to modify or turn off these corrections.
  • Handling Misspelled Words: AutoCorrect can automatically correct misspelled words. However, it might not always choose the correct spelling you intended. Always double-check to ensure the appropriate correction has been made.