Learn how to check the spelling of text in Excel, add words to your custom dictionary or AutoCorrect list and learn how to change spell checking options.
1. Open a worksheet with some spelling errors.
Note: to spell check the entire worksheet, simply select a single cell. If you select multiple cells, Excel only checks the spelling for those cells.
2. On the Review tab, in the Proofing group, click Spelling (or press F7).
3. Select a suggestion and click Change to correct the misspelling in cell A2.
Note: use the drop-down list to change the Dictionary language.
4. Click Change All to correct all instances of this misspelling (cell A2 and cell A7).
5. Click Ignore Once to ignore the misspelling in cell A2. Click Ignore All to ignore all instances of this misspelling.
6. Click Add to Dictionary to add this word to your custom dictionary.
7. To edit this list, click Options (see image above) and then click Custom Dictionaries (see image below).
Note: to directly open the Custom Dictionaries dialog box, click File, Options, Proofing and then click Custom Dictionaries.
8. Click AutoCorrect to add this word to your AutoCorrect list (every time you type anwer, Excel will replace it with answer).
9. To edit this list, click Options and then click AutoCorrect Options.
Note: you can also add abbreviations to your AutoCorrect list. For example, if you type ee.com, Excel can replace it with www.excel-easy.com.
10. To spell check words in a formula bar, select the words and press F7.
11. To spell check the entire workbook, hold down CTRL to select multiple sheets and press F7.
12. By default, Excel ignores words in UPPERCASE, ignores words that contain numbers, ignores internet and file addresses and flags repeated words.
Note: to change these spell checking options, click File, Options, Proofing.
Feb 25, 2016, 10:24 am EST | 4 min read
Excel’s spell check feature doesn’t have all the bells and whistles that Word’s does, but it does provide basic spell-checking functionality. You can check the spelling of words in the cells of a worksheet and add words to the dictionary.
Unfortunately, Excel does not check your spelling as you type (by underlining them in red) like Word does. You are only notified that a word is spelled wrong when you run the spell check.
How to Spell Check the Current Worksheet
To spell check a worksheet, click the tab at the bottom of the screen for the worksheet on which you want to run the spell check.
When you run the spell check, it starts from whichever cell is currently selected, so, if you want to start the spell check at the “beginning” of the worksheet, put the cursor on cell “A1” before starting.
When you’re ready to start the spell check, click the “Review” tab.
Click “Spelling” in the “Proofing” section. You can also press “F7” with any tab on the ribbon active to start the spell check.
The cell containing the first word not found in the dictionary is highlighted and the “Spelling” dialog box displays. The questionable word displays in the “Not in Dictionary” edit box. You can choose to “Ignore Once” or to “Ignore All” occurrences of the misspelled word if the word is actually correct for your purposes. If that’s the case, you can choose to “Add to Dictionary” if the word is one you use often.
If you’ve actually misspelled a word, you can either select the correctly spelled word from the list of “Suggestions” or enter the correct spelling in the “Not in Dictionary” edit box (if it’s not listed in the “Suggestions” list). Then, click “Change”. To change all occurrences of this error with the same change, click “Change All”.
If the questionable word is one you tend to mistype often, you can quickly set up an AutoCorrect entry for it so it will be automatically corrected the next time you make the mistake. To do this, either enter the correct word in the “Not in Dictionary” edit box or choose it from the “Suggestions” list and click “AutoCorrect” on the “Spelling” dialog box. In addition to correcting the word in your worksheet, an AutoCorrect entry is automatically created. The next time you type the incorrect word the same way, it will be automatically replaced with the replacement word you specified. We talk about AutoCorrect entries and how to create them in our article about assigning keyboard shortcuts to symbols in Excel.
When the spell check has finished, a dialog box displays telling you so. Click “OK” to close it.
Notice that the word “Refridgerator” on the “Invoice” worksheet was not found in the spell check of this worksheet. That’s because it’s the result of a formula in that cell that grabbed the word from a cell on the “Product Database” worksheet based on the “Item Code” entered on the “Invoice” worksheet. To correct “Refridgerator”, we need to run a spell check on the “Product Database” worksheet, which we will do in the next section.
Remember when we said you should select the first cell of a worksheet (“A1”) before starting a spell check? If you forgot, and started the spell check from any other cell than “A1”, you will be asked at this point whether you want to continue checking the spelling at the beginning of the worksheet before the spell check completes. Click “Yes” to check the remainder of the worksheet that has not been checked yet and then you will see the “Spell check complete” dialog box pictured above.
How to Spell Check All Worksheets in a Workbook at Once
By default, Excel spell checks your current worksheet. But what if you have a lot of worksheets in your workbook and you want to check them all? No worries. You can easily do that in one go.
In our example, there are two worksheets in our workbook, “Invoice” and “Product Database”. In the previous section, we only checked the “Invoice” worksheet. Now, we will select both of the worksheets in our workbook so they will both be spell checked without having to do each separately.
To spell check all the worksheets in a workbook, right-click on the current worksheet tab at the bottom of the Excel window and select “Select All Sheets” from the popup menu.
Notice in the above image that the currently selected worksheet tab displays in white and the inactive tab displays in gray. When all worksheet tabs are selected, they all display with a white background, as shown below.
Now when you start the spell check, it will check all the worksheets in the workbook. In our case, when the spell check gets to the second worksheet, or the “Product Database” worksheet, it finds a spelling error. To correct the error, we select the correct word in the “Suggestions” list box and click “Change”. As we mentioned earlier in this article, if we think we misspelled the same word the same way in other cells in our workbook, we can click “Change All” to correct them all at once with the same corrected word.
Remember, you can also type the correct word in the “Not in Dictionary” edit box and click “Change” to correct the error.
When the spell check is complete, and the “Spell check complete” dialog box displays, you may notice that the last corrected error doesn’t seem to have been corrected in the cell on the worksheet.
Don’t worry. When you click “OK” to close the dialog box, the corrected word displays in the cell.
You can use custom dictionaries to add words you use often to the dictionary, that are not already in the default built-in dictionary, as well as delete words you added using the “Add to Dictionary” button on the “Spelling” dialog box. You can even create additional custom dictionaries. The spell check can also be limited to use of the main dictionary only, even if there are custom dictionaries available.
Microsoft Excel doesn’t have advanced capabilities like grammar checking and correction but still, it offers the basic spell checking functionality. This built-in spell checker in Microsoft Excel can help you to double-check your excel sheets before you send them across to someone else.
One thing that I would like to point out is that the spell-checking capability of Excel is very limited. I mean, unlike MS Word, Excel doesn’t underline the misspelled words as you write them. It will only tell you about a misspelled word when you hit the spell check button.
Table of Contents
How to check spellings in Microsoft Excel:
Checking spellings in excel is very easy. Follow the below steps to perform a spell check in Excel.
- With your excel spreadsheet opened, simply navigate to the ‘Review’ tab in the ribbon.
- In the ‘Review’ tab there is an option ‘Spelling’ as shown in the image.
- Clicking this option will initiate the spell checking.
Now there is one important thing that I would like to highlight. Before starting the spell checking if your cursor was on the ‘A1’ cell then excel will start to spell checking from that cell. If your cursor was on some ‘K10’ cell then spell checking will start from that particular cell. But in this case, after reaching the end of the worksheet it will ask you “Do you want to continue checking at the beginning of the sheet?”
If you click the ‘Yes’ button then it will check all the left cells, else if you select ‘No’ then it will leave the other cells as it is.
Shortcut Key for Spell-checking:
If you don’t like to use the spell-checking functionality using the button present on the Excel ribbon then you can also do this by using a shortcut key. The shortcut key for this is ‘F7’.
While opening a spreadsheet if you press ‘F7’, then it will start the spell checking process.
Spell-check Multiple Sheets at Once:
While using the spell-check option you will realize that it can only check spellings on the active sheet. But by following the below method you will be able to check spellings on multiple sheets at once.
- Open the excel sheet, now right-click on the name of your excel sheet.
- This will open a menu, select the option that says “Select All Sheets”. Now all the available sheets in your excel file will be selected.
- After this start the spell checking process by navigating to Review>Spellings, or by using the ‘F7’ key.
Highlight Misspelled words by using a Macro:
Finding misspelled words becomes quite easy by using the below macro. This macro changes the background color of the cells where misspelled words are present. This makes it easier for anyone to find the wrongly spelled words just by viewing the sheet.
To use this macro follow the below steps:
- Open the excel sheet for which you want to highlight the misspelled cells.
- Next, press the “Alt+F11” keys, this will open Excel VBA editor.
- Navigate to Insert>Module.
- Paste the following code inside the editor.
- After pasting the code press the ‘F5’ key to run the macro.
- Next check your sheet, all the cells with misspelled words would have been highlighted in aqua color.
So, this was all about spell check in excel. If you come across any difficulty while using this option, please share it in the comments section.
You May Also Like
Well, I am Ankit Kaul, the founder of Excel Trick. I am a die-hard fan of Microsoft Excel and have been working with spreadsheets for the past 10+ years. My only aim is to turn you guys into ‘Excel Geeks’. Check out more about me here.
- Excel Tips
- Excel Functions
- Excel Formulas
- Word Tips
- Outlook Tips
How to spell check all sheets or entire workbook at once in Excel?
This article is talking about spelling check in all sheets or entire workbook at once in Excel.
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Please do as follows to spell check all sheets or entire workbook at once in Excel.
1. Right click on any sheet tab in the workbook you need to spell check, then click Select All Sheets from the context menu. See screenshot:
2. Now all sheets in the current workbook are selected. Please click Review > Spelling as below screenshot shown.
3. In the popping up Microsoft Excel dialog box, click the Yes button.
4. In the Spelling dialog box, select the correct word in the Suggestions list box you need, and then click the Change All button. See screenshot:
5. Then another Microsoft Excel dialog box pops up to tell you the completion of spell checking, please click the OK button.
6. And the spelling check has been applied to all sheets, then right click the sheet tab and select Ungroup Sheets to cancel all sheets selecting.
- Sfaturi Excel
- Funcții Excel
- Formule Excel
- Sfaturi pentru cuvinte
- Sfaturi Outlook
Cum se verifică ortografic toate foile sau întregul registru de lucru simultan în Excel?
Acest articol vorbește despre verificarea ortografiei în toate foile sau întregul registru de lucru simultan în Excel.
Uimitor! Utilizarea unor file eficiente în Excel, cum ar fi Chrome, Firefox și Safari!
Economisiți 50% din timp și reduceți mii de clicuri de mouse pentru dvs. în fiecare zi!
Vă rugăm să faceți următoarele pentru a verifica ortografic toate foile sau întregul registru de lucru simultan în Excel.
1. Faceți clic dreapta pe orice filă a foii din registrul de lucru pe care trebuie să o verificați ortografic, apoi faceți clic pe Selectați Toate foile din meniul contextual. Vedeți captura de ecran:
2. Acum sunt selectate toate foile din registrul de lucru curent. Vă rugăm să faceți clic pe Recenzie > Ortografie după cum se arată în imaginea de mai jos.
3. În fereastra pop-up Microsoft Excel , faceți clic pe Da butonul.
4. În Ortografie caseta de dialog, selectați cuvântul corect în sugestii casetă de listă de care aveți nevoie, apoi faceți clic pe Schimbă-le pe toate buton. Vedeți captura de ecran:
5. Apoi alta Microsoft Excel se afișează caseta de dialog pentru a vă informa despre finalizarea verificării ortografice, faceți clic pe OK butonul.
6. Și verificarea ortografiei a fost aplicată tuturor foilor, apoi faceți clic dreapta pe fila foi și selectați Dezgropați Foi pentru a anula toate foile selectate.
- Jun 14, 2002
Some videos you may like
- Jun 14, 2002
make a macro-assigned spell-check button and use something like:
Cells.CheckSpelling CustomDictionary:=”CUSTOM.DIC”, IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=1033
You could just put the button on the menu bar or anywhere for that matter.
This message was edited by Corticus on 2002-06-14 05:50
This message was edited by Corticus on 2002-06-14 05:51
- Jun 14, 2002
You could do this with a simple macro.
You’ll need to change Sheet1 to whatever your sheet name is. This macro is basically doing the same as unprotecting the sheet, clicking Tools, Spelling, running through the normal spell check procedure and then protecting it again after. I guess that the user would then have the ability to change your the Locked cells on your worksheet BUT only if those locked cells contain words that the spell checker doesn’t recognise.
- Jun 14, 2002
- Mar 23, 2009
I found this question which was asked back in July of 2002. I am having the same problem and this didn’t help.
I believe I did everything it said but when another person opens the sheet and tries to spell check it he gets a ” It gives me a “macros disabled” box. It says the security settings are too high” warning. I don’t know how I disabled the macros.
I’m using Excel 2003. Can anyone shed some light on this?
- Mar 23, 2009
Welcome to the Board!
By default, Excel Macro Security is set to High. Your user will need to goto Tools–>Macro–>Security and set it to Low (only if he has a virus scan program enabled).
You can also look in the help file for “Self-Cert”, which will let you digitally sign your code.
Hope that helps,
- Mar 24, 2009
- Aug 21, 2009
I ran across a problem with the aforementioned method. When performing the spell check, it did operate as normal EXCEPT that it didn’t show which cell had the misspelled word. If you are having the same problem, instead of using
Cells.CheckSpelling CustomDictionary:=”CUSTOM.DIC”, IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=1033
as the command, try using the following:
This has been working for me in taking me to the correct cell. (sometimes we use “made-up” acronyms or abbreviations and need to see the offending cell to know if the “misspelling” is accurate or not. This seems to have fixed our problem.)
- I want to.
- Get started with computers
- Learn Microsoft Office
- Apply for a job
- Improve my work skills
- Design nice-looking docs
- Office 2019 | 2016 | 2013
- Excel Formulas
- Basic Skills
- Smartphones & Tablets
- Typing Tutorial
- Internet Skills
- Online Safety
- Social Media
- Search Better
- Google Docs
- Google Sheets
- Work & Career
- Career Planning
- Resume Writing
- Cover Letters
- Job Search and Networking
- Business Communication
- Skills for Today
- Adapting to Change
- 3D Printing
- Freelance Work
- Personal Finance
- Sharing Economy
- Creativity & Design
- Graphic Design
- Image Editing
- Core Skills
- Language Learning
- For Educators
- Staff Picks
- All Topics
Lesson 11: Checking Spelling
Before sharing a workbook, you’ll want to make sure it doesn’t include any spelling errors. Fortunately, Excel includes a Spell Check tool you can use to make sure everything in your workbook is spelled correctly.
If you’ve used the Spell Check feature in Microsoft Word, just be aware that the Spell Check tool in Excel, while helpful, is not as powerful. For example, it won’t check for grammar issues or check spelling as you type.
To use Spell Check:
- From the Review tab, click the Spelling command.
If there are no appropriate suggestions, you can also enter the correct spelling manually.
Ignoring spelling “errors”
Spell Check isn’t always correct. It will sometimes mark certain words as incorrect even if they’re spelled correctly. This often happens with names, which may not be in the dictionary. You can choose not to change a spelling “error” using one of the following three options:
- Ignore Once: This will skip the word without changing it.
- Ignore All: This will skip the word without changing it and also skip all other instances of the word in your worksheet.
- Add: This adds the word to the dictionary so it will never appear as an error again. Make sure the word is spelled correctly before choosing this option.
How to Perform a Spell Check in Excel (Quick Guide)
If you want to perform a spell check in Excel:
Select the region to be checked.
Click on the Spelling option, which is located in the ‘Proofing’ group, on the Review table of the Excel ribbon.
These steps are described in further detail below:
Step 1 – Select the region to be checked
As with other basic operations in Excel, the spell check is only applied to the current selection. I.e.:
- If you select a single cell, the whole of the current worksheet will be checked;
- If you select a range of cells in a worksheet, just the selected range will be checked;
If you select multiple worksheets, all of these are checked.
Step 2 – Select the Spelling option in the Excel Ribbon
Click on the Spelling option, to perform the spell check. This is located in the ‘Proofing’ group, on the Review tab of the Excel ribbon (see below).
Step 3 – Use The ‘Spelling’ Dialog Box To Correct Or Ignore Any Spelling Errors.
If there are no spelling errors in the checked range, a message box will pop-up, with the message “Spell check complete. You’re good to go!”.
If Excel does find some spelling errors, you will be presented with the ‘Spelling’ dialog box (see below).
The ‘Spelling’ dialog box highlights the first spelling error that it has found and gives you possible alternative spellings for this word. From this dialog box, you can request that Excel takes one of the following actions:
Ignore (i.e. do not correct) the word that Excel has highlighted, by either:
- Selecting the Ignore Once button to ignore just the current occurrence of the mis-spelled word.
- Selecting the Ignore All button to ignore all occurrences of the word that have this spelling.
- Selecting the Add to Dictionary button to add the word to your Excel dictionary, so that it is not highlighted again, in the future.
Replace the highlighted word with one of the suggested replacement words in the scroll-down menu.
If you select a replacement word, you can then either:
- Select the Change button to replace just the current occurrence of the mis-spelled word.
- Select the Change All button to replace all occurrences of the word that have this spelling.
- Select the AutoCorrect button to replace just the current occurrence of the mis-spelled word, but to also add the mis-spelling to the Excel AutoCorrect list, so that this spelling is automatically corrected whenever it is typed in future.
Once you have specified what is to be done for the first highlighted word, Excel will move onto the next word that it believes may be mis-spelled. This is repeated until the entire range has been checked.
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Most of the time, you don’t need to worry about your spelling in Excel.
You have some column and row labels, and that’s about it. Excel is more often full of numbers than of text.
But sometimes you need to see if you’ve made any spelling errors. Whether that’s in column and row labels or in an entire spreadsheet, Excel can help.
Here’s everything you need to know about spell check in Excel…
In addition to the basics of spell check, we’ll also cover a few of the options that you can use to customize how it behaves.
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.
Table of Contents
Get your FREE exercise file
Spell checking in Excel is easy, but it’s always nice to be able to work with an example spreadsheet.
Download the free workbook below to follow along!
Download the FREE Exercise File
How to check spelling in Excel
Unlike Word and PowerPoint, Excel doesn’t automatically highlight misspelled words for you.
So you’ll need to run a spell check manually.
There are 2 ways to do that.
The first is to hit F7 on your keyboard. That brings up the Spelling window:
This is just like the spell-check window in every other Microsoft Office app. At the top of the window, you’ll see the word that Excel has flagged.
Below that, it gives you options to replace it with. All you need to do is select one of the options and hit Change. If you want to replace all the instances of that word, you can click Change All.
If Excel has flagged this word in error, you can tell it to Ignore Once, in which case it will flag that word next time you check the spelling of your document, or Ignore All to never see it brought up again.
To add the word to the custom dictionary so it doesn’t get flagged again in any document, hit Add to Dictionary.
You can also start the spell check by clicking the Spelling button in the Review tab of the Ribbon: