EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel AutoCorrect
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel AutoCorrect

By Ashwani JaiswalAshwani Jaiswal

Feature Image

Excel AutoCorrect (Table of Contents)

  • AutoCorrect in Excel
  • How to use AutoCorrect Options in Excel?

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?

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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,368 ratings)

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

AutoCorrect example 1-5

Once we click on Add, we will see that word is added in 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 can see below, we typed FUTHER again, and once we add space, it automatically gets corrected.

AutoCorrect example 1-7

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.

More Formatting options

With the help of the above-mentioned options, we can change the language, verbal type, change the case sensitiveness 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, 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.

AutoCorrect example 2-2

We have entered a google weblink, 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 or not.

AutoCorrect example 2-4

As we can see 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. 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.

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

Recommended Articles

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 –

  1. Excel AutoSave
  2. Auto Numbering in Excel
  3. AutoFill in Excel
  4. Excel Word Count
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
2 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • 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

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

EDUCBA
Free Excel Course

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

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

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

EDUCBA Login

Forgot Password?

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

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

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

EDUCBA

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

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

Let’s Get Started

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

EDUCBA

Download AutoCorrect Excel Template

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