As the name suggests, Auto Correct is an Excel feature that auto-correct misspelled words. But it is not only limited to correcting misspelled words. 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,
In this tutorial, you will learn the different options available for use 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:
- First, go to the “File” tab in the ribbon and then click on “Options” and you will get the “Excel Options” dialog box opened.
- After that, click on “Proofing” from the left side panel and then click on “AutoCorrect Options”.
- At this point, you will get the “AutoCorrect” dialog box opened with all the default options already selected.
- 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 Tab Options
There are many options available in AutoCorrect, which are by default selected to be used with the AutoCorrect feature. Here we have explained the definitions of that options for you to understand them.
- Correct two initial capitals: This option, when enabled, auto-corrects the first two initial 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.
- 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.
- 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”.
- 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”.
- 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, when we enter them in the spreadsheet, will get auto-replaced with the pre-defined results. You can remove some pre-defined words from the list and can expand the list by adding more to that list.
The AutoCorrect feature also has the option to set some exceptions. You will find the predefined list under exceptions which you can expand by adding more exceptions or delete by removing any not required exceptions from the list.
- Under the AutoCorrect tab, click on the “Exceptions” button.
- Once you click on the “Exceptions” button, you will get the “AutoCorrect Exceptions” dialog box opened.
- 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.
- 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.
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
Autoformat tab consists of three by default selected auto-formatting options that are very helpful while working in excel, which is explained below:
- 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. If you do not want to convert those links to hyperlinks, un-select this option.
- New rows and columns in the table: You have always seen when you enter any value in the adjacent column or row of the excel table, the table will get expanded up to that row or column by including them in the table. All that happens due to this option. If you disable it, the excel table will not get auto-expanded anymore.
- Fill formulas in the table: This option auto copy your entered formula to all the down cells in the same column within the excel table by adjusting the cell references of the formula.
The action tab can create additional actions based on specific words, text, or values. By default, you will find the additional actions disabled, and to enable it, select the “Enable additional actions in right-click menu” option.
Excel only has Date (XML) as pre-defined additional action in the list, but you can create more per your need.
Once you enable this option, the date action will get enabled as it is pre-defined by Excel, which means after this, when you enter the date in the cell.
If you right-click on it, Excel will show you the outlook calendar options by clicking on which you will get routed to your calendar.
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.
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” options and other tab options.