Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Autocorrect itself means that correction of something automatically when it is incorrect, we have seen this feature in Microsoft word and in excel it is called as proofing which is available in the options tab of excel, using this feature it can automatically correct common misspelled words or finish a short phrase to a full sentence or even pop up a full form of an abbreviation.
The AutoCorrect is a very excellent option provided in Excel Microsoft Office. AutoCorrect in excel will automatically correct the text which is wrongly spelled. Microsoft Excel has some list of typical words that correct the spellings of them. The AutoCorrect Option in excel will not only correct the spellings of the words and also excel autocorrects the capitalization of the first word after a full stop.
Examples of AutoCorrect in Excel
There can be a lot of examples regarding the AutoCorrect option in Excel.
If I type “ehr” in excel and press enter, it automatically corrects the word to “her” as shown in the below screenshot.
The above screenshot is having spelling “ehr” after I click to enter, then it automatically changes the spelling to “her”. This is shown in below screenshot.
The above screenshot is done with the excel autocorrect option after clicking Enter.
Not all the spellings get excel autocorrected with this feature. As I said before it has some list of words in that feature that autocorrects.
In this example, teacher spelling is written wrong, and it is not identified by the feature and not auto-corrected. Now we can add the spelling to the list and then it can be corrected. This can be shown below.
The spelling is corrected.
The step by step process is as follows to add the spelling to the list.
Step1: Goto File Menu
Step 2: Now from there go to Options.
Step 3: click the “Options” button. You will see a window of having many options as shown in below screenshot.
Step4: Now select Proofing option, and then again another window will be opened and in that select “AutoCorrect Options” in that window and again another window will be opened which is as shown in below screenshot.
Step5: Now another window will be opened for “AutoCorrect Options “. In that, the excel Autocorrect is the default tab selected in that window as shown below.
Step6: In that window, we find that all the checkboxes are checked by default, that means all the features are applied automatically if you want to turn them off that can be done just by unchecking the checkbox beside the feature.
Now our requirement is to add the user defined text for replacing the text. That can be done by writing the misspelled word in “replace” Text field and correct spelling in “with” field. This is as shown below.
Write the word to be replaced in “replace” field and the word with which it is replaced in “with” field. Now click on the ADD button and then click “OK”. Then click “OK” again in the main “Proofing” window. The user-defined text will be added into the list. Now the added text can be used from next time. The wrongly spelled word is now corrected to the right spelling.
The screenshot for that would be as shown below.
Here we can see that the text got corrected. The correct spelling can be seen in the highlighted cell.
Detailed Explanation of AutoCorrect Function in Excel
There are a series of steps to select the AutoCorrect feature in Microsoft Excel.
Step1: After opening the Microsoft Excel, Go to File Menu and Select “Options” as shown in the screenshot.
Step2: In Options Goto “Proofing” option.
Step3: In Proofing click on Excel “AutoCorrect options”.
Step4: The window for AutoCorrect options will appear as shown below. The Excel AutoCorrect tab is the default option which is selected in the window of AutoCorrect.
Here autocorrect option in Excel is checked by default if you want to uncheck the autocorrect option, uncheck the option for “ Replace text as you type”. Then after unchecking this, now one will not be able to see the excel autocorrect option for spellings. For example, if you type “ehr” it will be shown as “ehr” but not as “her”.
The option “Replace text as you type” is only for toggling of auto-correction of spellings only in the written text before clicking Enter button.
The drawback in this feature is it does not correct all the words which are spelled, it has some list of words shown in the window if you observe, some most common words are present in the list. Also, there is another option of adding own text to be corrected. This is shown in below screenshot.
In the above screenshot, there is an option to add the user-defined spellings for the auto-correction of spellings, write the wrongly spelled word in replace text field and the correct spelling in “with” field. After entering the text, click on OK and then again click ok in Proofing window. Now you can be able to use the user defined words for auto-correction of misspelled words.
There are many options in this window to check or uncheck them, by default they are checked and if you want to uncheck them or don’t want to use them, then we can uncheck the excel checkbox.
The first option in them is,
1) Correct two initial capitals: If you turn off or uncheck the checkbox for this, you will not be able to correct the first initial capitals.
2) Capitalize first letters of sentences: This option will automatically capitalize the first letter of a sentence. By turning off this option, you will not be able to use the auto capitalization option in next time.
3) Capitalize names of days: This option will automatically capitalize the names of the days in a week.
4) Correct accidental use of Caps Lock Key: Accidentally sometimes the Capital letters are used in between the words. To correct those words or sentences then this option is useful.
Usage of AutoCorrect Excel Feature
- This feature main purpose is to correct the spellings of the words in a sentence if they are wrongly written in spellings.
- The next feature is this feature also auto-capitalizes the first letter of every word in a sentence. We can turn off this option as discussed above.
- As a part of the auto capitalization feature, this option automatically capitalizes the first letter of every word of a day in a week.
- Sometimes we write capital letters accidentally in between the words. That capital letters also can be corrected into small letters with this feature.
- The first two initial words also can be made capital with this option. One can even turn off this feature as discussed above.
- We can even add the user-defined spellings which can be wrongly spelled in the replace text field space as there are only some words in that list.
- Not only words symbols which the user thinks that he is frequently using them and in any case, but they also don’t want to misspell the spelling in any time. In this case that symbols can be added to the list so that they cannot be missed.
For example Copy Right ©, the symbol can be used by using the text “(c)”.
Important Points to be Remembered
- Excel AutoCorrect feature has only a list of words for auto-correction of spellings.
- Excel AutoCorrect feature is by default applied in Microsoft Excel, as per the requirement we can turn off this feature.
- As Excel AutoCorrect feature is automatic some unwanted changes also may happen due to this auto feature option. Then we need to turn off the options which are not necessary for that particular time so that our work is not interrupted.
This has been a guide to AutoCorrect in Excel. Here we learn how to use AutoCorrect in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –