Categories
Life hack

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

7. To edit this list, click Options (see image above) and then click Custom Dictionaries (see image below).

How to spell check worksheets in excel

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

How to spell check worksheets in excel

9. To edit this list, click Options and then click AutoCorrect Options.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

Note: to change these spell checking options, click File, Options, Proofing.

@howtogeek
Feb 25, 2016, 10:24 am EST | 4 min read

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

Click “Spelling” in the “Proofing” section. You can also press “F7” with any tab on the ribbon active to start the spell check.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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 worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

Don’t worry. When you click “OK” to close the dialog box, the corrected word displays in the cell.

How to spell check worksheets in excel

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?”

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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

How to spell check worksheets in excel

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:

How to spell check worksheets in excel

2. Now all sheets in the current workbook are selected. Please click Review > Spelling as below screenshot shown.

How to spell check worksheets in excel

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:

How to spell check worksheets in excel

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:

How to spell check worksheets in excel

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.

How to spell check worksheets in excel

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:

How to spell check worksheets in excel

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.

dpmicka

Board Regular
  • Jun 14, 2002
  • #1
  • Some videos you may like

    Excel Facts

    Corticus

    Well-known Member
    • Jun 14, 2002
  • #2
  • make a macro-assigned spell-check button and use something like:

    Sub SpellCheck()
    ActiveSheet.Unprotect
    Cells.CheckSpelling CustomDictionary:=”CUSTOM.DIC”, IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=1033
    ActiveSheet.Protect
    End Sub()

    You could just put the button on the menu bar or anywhere for that matter.
    Corticus
    This message was edited by Corticus on 2002-06-14 05:50
    This message was edited by Corticus on 2002-06-14 05:51

    MrExcel MVP
    • Jun 14, 2002
  • #3
  • 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.

    dpmicka

    Board Regular
    • Jun 14, 2002
  • #4
  • mhadaway

    New Member
    • Mar 23, 2009
  • #5
  • 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?

    Smitty

    Legend
    • Mar 23, 2009
  • #6
  • 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,

    mhadaway

    New Member
    • Mar 24, 2009
  • #7
  • kbarre

    New Member
    • Aug 21, 2009
  • #8
  • 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
    or
    ActiveSheet.CheckSpelling

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

    Checking Spelling

    • I want to.
      • Get started with computers
      • Learn Microsoft Office
      • Apply for a job
      • Improve my work skills
      • Design nice-looking docs
      • More.
    • Microsoft
      • Office 2019 | 2016 | 2013
      • Word
      • Excel
      • PowerPoint
      • Access
      • Excel Formulas
      • More.
    • Basic Skills
      • Computers
      • Smartphones & Tablets
      • Typing Tutorial
      • Windows
      • More.
    • Internet Skills
      • Internet
      • Online Safety
      • Social Media
      • Email
      • Search Better
      • More.
    • Google
      • Gmail
      • Google Docs
      • Google Sheets
      • More.
    • Work & Career
      • Career Planning
      • Resume Writing
      • Cover Letters
      • Job Search and Networking
      • Business Communication
      • More.
    • Skills for Today
      • Adapting to Change
      • 3D Printing
      • Wearables
      • Freelance Work
      • Personal Finance
      • Sharing Economy
      • Decision-Making
      • More.
    • Creativity & Design
      • Graphic Design
      • Creativity
      • Photography
      • Image Editing
      • Photoshop
      • More.
    • Core Skills
      • Math
      • Reading
      • Grammar
      • Language Learning
      • More.
    • For Educators
    • Translations
    • Staff Picks
    • All Topics

    How to spell check worksheets in excel

    Lesson 11: Checking Spelling

    Introduction

    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:

    1. From the Review tab, click the Spelling command.

    How to spell check worksheets in excel

    How to spell check worksheets in excel

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

    How to spell check worksheets in excel

    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 spell check worksheets in excel

    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:

    How to spell check worksheets in excel

    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: