Excel AutoCorrect (Table of Contents)
AutoCorrect in Excel
Most of the people are not aware that Excel also has an AutoCorrect feature in Microsoft word. We many times make grammatical mistakes, and this may happen when we type and text in excel as well. AutoCorrect feature in Excel allows us to correct the incorrect word or spelling automatically. The autoCorrect feature helps us avoid making typos (typing mistakes) while the data may be used to present, or it can be important to some work.
How to Use?
Using the Autocorrect feature, we can correct misspelt words and be used to change abbreviations to full text or replace longer phrases with shortcodes. It can also insert checkmarks, bullets, and other special symbols.
Let’s understand the working of AutoCorrect Options in Excel with some examples.
For accessing the AutoCorrect feature in Excel, go to the File menu. From there, go to Options and select Proofing from Excel Options.
We all have some or few words which we often mistakenly type incorrectly. This is because, unintentionally, we do not know how to spell, or in our subconscious, we already have incorrect spells saved. This can happen to anyone. For this, we check the correct spelling of those words and save it in the AutoCorrect dictionary to avoid further mistakes.
Let’s consider a sentence where we have already notices and see a typo, as shown below.
As we can see above, here, we have incorrectly spelled FURTHER as FUTHER. And this word did not get AutoCorrected, which means it is not saved in Excel AutoCorrect dictionary. So for that, let’s go to the File menu as shown below.
Now from there, go to Options.
And select Proofing from the Excel Options window as shown below. As we can see, in Proofing, there is a feature of AutoCorrect Options and some more inbuilt features related to AutoCorrect below in the same box. Select AutoCorrect Option first.
Once we click on AutoCorrect Options, we will get its box. In that, go to the AutoCorrect tab. Now we can search our word FUTHER in the replace box, or we can scroll up and down to see whether our desired word has already been added or not. As that word was not AutoCorrected, so we can add it here. For that, in replace box type word FUTHER and replace it with FURTHER, which is the correct word as shown below. After that, click on Add button to add that word to the dictionary.
Once we click on Add, we will see that word is added in the list at the bottom. Now click on OK to exit.
Now let’s test it by typing the same sentence again. As we can see below, we typed FUTHER again, and once we add space, it automatically gets corrected.
By this, we can add those words in the excel dictionary, which we often type incorrectly.
For more formatting, we can select more options from the Excel Options window, as shown below.
With the help of the above-mentioned options, we can change the language, verbal type, change the case sensitiveness from Upper to Lower.
To AutoCorrect in excel, there are some more AutoCorrect features in excel. From the AutoCorrect option, along with text and words, we can AutoCorrect the data used from external sources in excel corrected automatically in AutoFormat As You Type tab as shown below. We can format rows and columns to add a new one; we can apply the hyperlinks to those paths, taking us to any specific page and even auto-filling the formula.
For testing, let’s uncheck with the 1st option, which is the Internet and Network path with hyperlinks as shown below, and click OK to see if hyperlinks for the internet path works or not.
We have entered a google weblink, and no hyperlink is generated for that, as shown below.
Now let’s check the 1st option from AutoCorrect Window again and see if we get hyperlinks or not.
As we can see below, we are now getting hyperlinks for the website path again.
The next tab is Action. This is the customize tab for AutoCorrect in Excel. We make any specific changes and add new entries. By clicking on the More Actions button, as shown in the below screenshot, it will take us to the Microsoft support web page. We can select any action option if it is available for the version we are currently using.
In the tab of AutoCorrect, we have the Math AutoCorrect option also. This is the mathematical auto-correction where we can add new mathematical characters, which we use frequently. So instead of going into the equation, we can add and define those characters here as we did for text and words. Let’s add a Degree sign. For that in Math AutoCorrect window, enter \deg in replace the box and replace that with degree signature ° as shown below. Once we add it, we will get that value at the bottom of the list.
- By this, we can avoid incorrect work typing mistakes, which can hamper our professional skills.
- Frequently used words in which we often make mistakes in typing can add a plus point in the data output.
Things To Remember
- For regular users, it is very important to fix those words which are typed incorrectly.
- Always check the data before submitting or using somewhere, with all spelling and texts to avoid those conditions where AutoCorrect is working if any word is not added in a dictionary.
- When not required, turn off the AutoCorrect because, in some situation, we need to keep the words as it is supposed to be added. In that case, AutoCorrect may correct with a different word which is not even required.
- We would recommend not to use Hyperlinks for network and website because it may unnecessarily increase the size, and sometimes files may get frozen if there are too many hyperlinks in the worksheet.
This has been a guide to AutoCorrect in Excel. Here we discussed How to use AutoCorrect Options in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –