EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Spelling Check in Excel
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 and 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

Spelling Check in Excel

By Madhuri ThakurMadhuri Thakur

Spelling Check in Excel

Excel Spelling Check (Table of Contents)

  • Options to Check Spelling in Excel
  • How to Use Spelling Check Option in Excel?

How to Check Spelling in Excel?

In excel, we often encountered such cases where we have mistyped a word, but still, excel does not give any type of error. This is because Excel is more inclined towards working with numbers and not with text. So this is important that we do a manual spelling check in excel to make sure that our data is grammatically correct. In excel, the feature of automatically highlighting the wrongly typed word is not enabled; hence we need to manually check for any error by using the spell check option. Spell check is the inbuilt function that is available in excel and can be easily used by the keyboard shortcut that is the F7 key.

Options to Check Spelling in Excel

Let’s look at a few examples and the default options to check to spelling in excel.

#1 – Ignore Once

If the word seems wrong to excel but is actually a correct one, then we can choose to ignore the error. To run this function, press the F7 key.

Start Your Free Excel Course

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

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,768 ratings)

Spelling check in excel - Ignore Once

#2 – Ignore All Misspelled Word

If there is more than one occurrence of the misspelled word and we want that all such occurrences of the misspelled word should be ignored, we can choose to ignore all.

Spelling check in excel - Ignore All

#3 – Add to Dictionary

We can also add a custom word to the dictionary of excel so that the word is recognized by excel next time we have entered the same.

Spelling check in excel - Add to Dictionary

#4 – Change the Misspelled Word

If we want to change the word with the suggestions offered by excel, then we just need to select the correct word and select the option of “Change”.

Spelling check in excel - Change the Misspelled Word

#5 – Change All

We can choose not to review the errors one by one; we can just select the option of “change all”, and all the errors will be automatically corrected. This function should be used with caution.

Change All at once

#6 – AutoCorrect

This function will automatically change the wrongly typed word to the correct one if this function is selected. We do not need to do a spell check next time.

AutoCorrect

#7 – Options

If we are using a language that is different from “English (US)”, then we need to use the function “option” and change the dictionary to other languages as default.

Options

#8 – Cancel

We can at any time choose to cancel the pending errors.

Cancel

#9 – Dictionary Language

From this option, we can change the dictionary that should be referred to do a spelling check.

Dictionary Language

#10 – Undo Last

If we observed later that the last word that we have just corrected was a correct word in the first place, then we can choose Undo, the last option.

Undo Last

Explanation

  • The spelling check option works horizontally; this means that it will look from left to right and keep on going until the check is done. If we have errors horizontally, then also it will first check A1, B1, C1….. And not vertically. So we should first select the data.
  • Spelling check works by referring to the dictionary and searching the typed words from that dictionary. This is the same as a function of using Vlookup; if the data is present, then it’s ok else, we will get an error. The same is with the spell check; if the word is not found in the dictionary, then the spell check will return an error and offer a matching word that can be used.
  • In the case of using a spelling check, excel goes inside the cell value and treats that value as a text and a sequence of typed alphabets as a single word, separated with space. If in case the text that is typed is in all Upper case, then this word will not come under the spell check error.

How to Use Spelling Check Option in Excel?

The first step will be to choose the data that we want to check. This saves our time in case we just need to check some of the data.

Step #1 – Choose the Data.

Data

Step #2 – Select the Review tab and choose the option “Spelling”

Spelling Option

Step #3 – If we do not want to go through these options, then we can choose to use the keyboard shortcut that is F7.

Step #4 – From the window now, we can see which word has been typed wrong. The word that is identified as an error will come under the “Not in Dictionary” option.

Not in Dictionary

Step #5 – Now, we can also see which word matches best instead of a misspelled word can be seen under the option of “Suggestions”. After checking the suggestions, we can choose to change the misspelled word with the correct word by selecting the option of “Change”.

Suggestions

We can also choose to change all occurrences at once by using the “Change all” option.

Step #6 – We can now choose to skip reviewing the errors one by one and hence select the option of “Change All”.

Change All

Step #7 – By this time, the Text that we have will be free from any grammatical and spelling mistakes.

Things to Remember

  • This should be remembered that if a text is typed incomplete upper case, then this word will be skipped from checking and will not appear in the spelling check.
  • Any text that ends or starts with a numerical value is also skipped from checking. This means that a text such as “Text 123” or “123 Text” will be skipped in spell check.
  • If we have the same error multiple times and we have chosen to ignore all errors, then we will not get that error again for the review.
  • A word that is previously marked for “Autocorrect” will be changed to a correct word next time it has been entered. This means that if we intentionally want that wrong word, we need to remove it from the autocorrect option first.
  • Any web address is also not spotted as an error. This is because the web link is treated as custom text and not as a combination of words from the dictionary.
  • If we have entered an address that Is actually the folder address, then also this is not spotted as an error.
  • If we have added a misspelled word to the dictionary, then this will not again come under the spell check error screen.

Recommended Articles

This is a guide to Spelling Check-in Excel. Here we discuss the different options for spelling check and how to use these options in Excel, along with practical examples. You can also go through our other suggested articles –

  1. Excel AutoCorrect
  2. VBA Dictionary
  3. Excel Spell Check
  4. Excel Translate
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
0 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, 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 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.

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