EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Tools Excel AutoCorrect

Excel AutoCorrect

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 12, 2023

Feature Image

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.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Use autocorrect in excel?

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.

You can download this AutoCorrect Excel Template here – AutoCorrect Excel Template

Example #1

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.

AutoCorrect example 1-1

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.

File Menu

Now from there, go to Options.

AutoCorrect example 1-3

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.

AutoCorrect example 1-4

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 scroll up and down to see whether our desired word has already been added. As that word was not AutoCorrected, so we can add it here. For that, in replace box, type the 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.

AutoCorrect example 1-5

Once we click on Add, we will see that word is added to the list at the bottom. Now click on OK to exit.

AutoCorrect example 1-6

Now let’s test it by typing the same sentence again. As we see below, we typed FUTHER again, and once we added space, it automatically got corrected.

AutoCorrect example 1-7

By this, we can add those words to the Excel dictionary, which we often type incorrectly.

For more formatting, we can select more options from the Excel Options window, as shown below.

More Formatting options

With the help of the options mentioned above, we can change the language and verbal type and change the case sensitivity from Upper to Lower.

Example #2

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.

AutoCorrect example 2-1

For testing, let’s uncheck with the 1st option, the Internet and Network path with hyperlinks as shown below, and click OK to see if hyperlinks for the Internet path work.

AutoCorrect example 2-2

We have entered a Google web link, and no hyperlink is generated for that, as shown below.

AutoCorrect example 2-3

Now let’s check the 1st option from AutoCorrect Window again and see if we get hyperlinks.

AutoCorrect example 2-4

As shown below, we are now getting hyperlinks for the website path again.

Hyperlinks

Example #3

The next tab is Action. This is the customize tab for AutoCorrect in Excel. We make any specific changes and add new entries. Clicking on the More Actions button, as shown in the screenshot below, 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.

More Actions

Example #4

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 the 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.

Math option

Pros

  • 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 to the data output.

Things To Remember

  • Fixing incorrectly typed words is very important for regular users.
  • Always check the data before submitting or using it somewhere, with all spelling and texts, to avoid those conditions where AutoCorrect works if any word is not added to a dictionary.
  • When not required, turn off the AutoCorrect because, in some situations, we need to keep the words as they should be added. In that case, AutoCorrect may correct with a different word which is not even required.
  • We recommend not using Hyperlinks for networks and websites because it may unnecessarily increase the size. Sometimes files may get frozen if there are too many hyperlinks in the worksheet.

Recommended Articles

This has been a guide to AutoCorrect in Excel. Here we discussed How to use AutoCorrect Options in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Excel AutoSave
  2. Auto Numbering in Excel
  3. AutoFill in Excel
  4. Excel Word Count
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download AutoCorrect Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download AutoCorrect Excel Template

EDUCBA

डाउनलोड AutoCorrect Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW