Many times, users make mistakes while entering data to the Excel worksheet. In a hurry, they use wrong spellings in the Excel table. Unlike Word and Powerpoint, Excel often ignores spell check.
Microsoft Word and PowerPoint enable in-built spell checkers to check the incorrect spellings while writing paragraphs automatically. It underlines the misspelled word by a red color line. In contrast, Excel does not do this. Excel does not detect incorrect spelling.
his chapter will guide you on how one can spell check in an Excel worksheet for effective work. We have to check the spelling separately in MS Excel. We have a few simple steps to do that.
How spell checker work for Excel?
In Excel, the spell checker provides suggestions related to the spelling you have selected for spell checking. If Excel finds that word is correct, it does not give any spelling suggestion. Otherwise, it will provide numerous spelling suggestions to replace the word with them from its dictionary.
All you have to do; you need to follow few steps. Unlike MS Word, Excel does not perform this on behalf of the users. You have to check misspelled words manually in Excel.
Where to find spell check in Excel?
You can find the spell check named Spellings inside the Review tab present in the Excel ribbon. When you click the Spellings option here and it finds any incorrect word, it opens a dialogue box containing various options on it.
Review > Spelling
Here are the different options consist by the spell check dialogue box.
When spell check encounters an error in word, but you want to keep it as same as you wrote, click on this Ignore Once button on this dialogue box.
When Excel found a word misspelled but you want to keep all the instances of that word as is, click the Ignore All button.
Add to Dictionary
If a word is encountered as an incorrect word, it means that word is not added to the Excel dictionary. You can add it to the Excel dictionary by clicking on this Add to Dictionary button from here.
Whenever an error or misspelled detect, Spell Checker shows some suggestions related to that word. There can be one or more suggestions. Select one of them which you find relevant and click on the Change button to make changes.
This option is almost the same as the above Change option. It changes all the occurrences in the Excel worksheet from the suggested word selected from there.
AutoCorrect option is a special function of Excel that changes the misspelled word with the correct one automatically when you click on this. Similar to the other options of the spell checker, it exists just below the Change All button.
Dictionary Language is a dropdown list that consists of several regional languages. You can change the Excel dictionary language from this dropdown list.
Undo Last option allows the users to roll back the action if you mistakenly select the wrong spelling from here. You can undo that action and choose the correct one again.
Step to spell check of a single text/word in Excel
Excel allows the users to either check single or multiple cells text data together. We have an Excel document, as shown below. Using which we will show you each step.
To check the spelling of any single text in an Excel document, go for the following steps ahead:
Step 1: On the opened worksheet, select one word on which you have doubt it is incorrect, as shown below.
Step 2: In the Excel menu bar, navigate to the Review tab, and click on the Spelling option here.
Step 3: A spell check panel will open to show you the suggestion related to that word if the spell checker finds it incorrect. Otherwise, it will not show you any suggestions.
Note: This spell checker panel opens only when Excel found any misspelled word. Otherwise, this spell checker panel window does not open.
Step 4: Here, we will choose the first word Cappuccino from the suggestions list and click on the Change button. You can also click the AutoCorrect option to automatically update the word.
Step 5: When the word will be corrected, this panel will get closed and a popup message will show.
Step 6: You can see that the spelling is corrected now.
Step 7: E.g., if the word is already correct, it will show a popup as shown below.
This whole process was for single misspelled word checking. You can also add that particular keyword in your Excel dictionary or ignore it as well from here.
Step to spell check for multiple words
In Excel, you can check spellings for multiple cells together. If Excel founds any of the spelling incorrect in the selected cell, it will take you to spell checker, otherwise not. To check the spelling for multiple text data in Excel document, go for the following steps ahead:
Step 1: On the opened worksheet, select two or more cells to check the spelling. You can also choose a complete column/row or entire Excel worksheet.
Step 2: Now, navigate to the Review tab, where click on the Spelling option under the Proofing section, i.e., Review > Spellings.
Step 3: A panel will open with some suggestions to replace incorrect spellings with them if Excel found any misspelled word in the selected cell.
Here, it has found Choclate as the first misspelled word and shows suggestion to choose the correct one from the list.
Step 4: Choose the correct one, click on the Change button or use AutoCorrect to automatically select the correct spelling and move to the next misspelled word.
Note: Autocorrect always chooses the first spelling suggestion from the list, either it is correct or not in the consent of sentence. So, choose wisely.
Step 5: Next misspelled word correction has been suggested, i.e., catlet. Here, you will see that the second spelling is correct.
Select correct spelling and click on the Change button here.
Usually, it will suggest spelling suggestions for each misspelled word. So, it will show suggestions for all misspelled words.
Either use the autocorrect option here and move to the next misspelled keyword automatically or select them from the list manually one by one.
Step 6: When each keyword will be corrected, this panel will get closed and a popup message will show.
Step 7: You can see that all incorrect word has been replaced with new ones in one go.
Similarly, the same process you can follow for other columns and rows as well.
Things to notice while using spell checker in Excel
Here, something will happen opposite when you use this spell checker.
- When you select a single cell for spell checking, it will check the entire Excel worksheet, including header, footer, and comment also.
- In case you select the multiple cells or entire worksheet, it will check only one cell.
- To spell-check a single word in the formula bar, select the words.
This is what happens with Excel worksheets while using the spell checker tool in Excel.
It is a drawback of Excel that it does not enable auto-correction or error detection to check wrongly typed spellings.
Sometimes, a user needs the synonym for a word in Excel too. In MS Word application, you can get it very easily by right-clicking on that particular word and select Synonyms from the given options. It shows all the synonyms for that word present in the Word dictionary. But in Excel, you need to follow some extra steps to get the synonym for a word.
- In an Excel worksheet, select that particular word and go to the Review
- Here, click on Thesaurus under the Proofing section.
- On the right of the Excel worksheet screen, it will show you all the related synonyms as well as related other words for that selected word.
How useful was this post?
- Share review with rating here: Google Review
We are providing practical training (Labor Laws, Payroll, Salary Structure, PF-ESI Challan) and Labor Codes, Payroll Consultant Service & more:
- HR Generalist Practical Training + Certificate: https://oneclik.in/hr-generalist-practical-training/
- Labor Law + Payroll Practical Training + Certificate : https://oneclik.in/labor-law-payroll-practical-training-certificate/ (PF, ESI, Bonus, Payroll & more)
- HR Analytics Practical Training + Certificate: https://oneclik.in/hr-analytics-practical-training-certificate/
- Labor Code, 2020 (Crash Course) + Certificate: https://oneclik.in/labor-code2020-rules-practical-training-certificate-crash-course/
- Advance Excel Practical Training + Certificate: https://oneclik.in/advanced-excel-practical-training-certificate/
- Disciplinary Proceeding & Domestic Enquiry – Practical Training + Certificate: https://oneclik.in/disciplinary-proceeding-domestic-enquiry-short-term-course-with-latest-updates/
- PoSH Act, 2013 (Sexual Harassment Of Women At Workplace & Vishaka Guidelines) – Practical Training + Certificate: https://oneclik.in/sexual-harassment-of-women-at-workplace-vishaka-guidelines-short-term-course-with-latest-amendments/
- Compensation & Benefits – Practical Training + Certificate: https://oneclik.in/compensation-benefits-practical-training-certificate/
- Industrial Relations – Practical Training + Certificate: https://oneclik.in/industrial-relations-practical-training-certificate/
- Labour Code (2019 & 2020) With Latest Updates | Labour Bill (Labour-Law-Practical-Training): https://oneclik.in/labour-law-practical-training/ (Factory, Contact Labor, Maternity Act & more)
- PF – ESI Consultant Service: https://oneclik.in/pf-esi-consultant-service/
- Labor Law, Compliance & HR – Payroll Management
Get Latest HR, IR, Labor Law Updates, Case Studies & Regular Updates: (Join us on Social Media)
- Telegram Channel: “One Clik”
- Whatsapp Group: https://wa.me/919033016939
- Facebook: One Clik
- Linkedin: One Clik
- Instagram: oneclik_hr_management
- YouTube: One Clik
Disclaimer: All the information on this website/blog/post is published in good faith, fair use & for general informational purposes only and is not intended to constitute legal advice.