How to spell check worksheets in excel

To check spelling for any text on your worksheet, click Review > Spelling.

Tip: You can also press F7.

Here are some things that happen when you use the spelling checker:

If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.

If you select multiple cells, Excel checks spelling only for those cells.

To spell check words in a formula bar, select the words.

Note: Excel doesn’t check spelling in cells that contain formulas.

Correct spelling as you type

Both AutoComplete and AutoCorrect can help fix typing errors on the go.

AutoComplete, on by default, helps to maintain accuracy as you type by matching entries in other cells and does not check individual words in a cell, AutoComplete can be handy when creating formulas.

AutoCorrect fixes errors in a formula’s text, worksheet control, text box, and chart labels. Here’s how to use it:

Click File > Options.

Under the Proofing category, click AutoCorrect Options, and check the most likely typing errors.

Note: You can’t use AutoCorrect for text in a dialog box.

Additional resources

You can also check out Research, Thesaurus and Translate for more help with spelling and language.

On the Review tab, click Spelling or press F7 on the keyboard.

Note: The Spelling dialog box will not open if no spelling errors are detected, or if the word you are trying to add already exists in the dictionary.

Do any of the following.

Change the word

Under Suggestions, click the word that you want to use, and then click Change.

Change every occurrence of this word in this document

Under Suggestions, click the word that you want to use, and then click Change All.

Ignore this word and move on to the next misspelled word

Click Ignore.

Ignore every occurrence of this word in this document and move on to the next misspelled word

Click Ignore All.

Correct spelling as you type

You can use the AutoCorrect feature to correct typos and misspelled words. For more information, see Add, edit, or turn off automatic corrections.

To check spelling for any text on your worksheet, click Review > Proofing > Spelling.

Here are some things that happen when you use the spelling checker:

If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.

If you select multiple cells, Excel checks spelling only for those cells.

Note: Excel doesn’t check spelling in cells that contain formulas, but you can spell check words in the formula – just select the words in the formula bar.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

To check spelling for any text on your worksheet, click Review > Spelling.

Tip: You can also press F7.

Here are some things that happen when you use the spelling checker:

If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.

If you select multiple cells, Excel checks spelling only for those cells.

To spell check words in a formula bar, select the words.

Note: Excel doesn’t check spelling in cells that contain formulas.

Correct spelling as you type

Both AutoComplete and AutoCorrect can help fix typing errors on the go.

AutoComplete, on by default, helps to maintain accuracy as you type by matching entries in other cells and does not check individual words in a cell, AutoComplete can be handy when creating formulas.

AutoCorrect fixes errors in a formula’s text, worksheet control, text box, and chart labels. Here’s how to use it:

Click File > Options.

Under the Proofing category, click AutoCorrect Options, and check the most likely typing errors.

Note: You can’t use AutoCorrect for text in a dialog box.

Additional resources

You can also check out Research, Thesaurus and Translate for more help with spelling and language.

On the Review tab, click Spelling or press F7 on the keyboard.

Note: The Spelling dialog box will not open if no spelling errors are detected, or if the word you are trying to add already exists in the dictionary.

Do any of the following.

Change the word

Under Suggestions, click the word that you want to use, and then click Change.

Change every occurrence of this word in this document

Under Suggestions, click the word that you want to use, and then click Change All.

Ignore this word and move on to the next misspelled word

Click Ignore.

Ignore every occurrence of this word in this document and move on to the next misspelled word

Click Ignore All.

Correct spelling as you type

You can use the AutoCorrect feature to correct typos and misspelled words. For more information, see Add, edit, or turn off automatic corrections.

To check spelling for any text on your worksheet, click Review > Proofing > Spelling.

Here are some things that happen when you use the spelling checker:

If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.

If you select multiple cells, Excel checks spelling only for those cells.

Note: Excel doesn’t check spelling in cells that contain formulas, but you can spell check words in the formula – just select the words in the formula bar.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

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.

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

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.

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

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.

How to spell check worksheets in excel

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.

Subscribe and be a part of our 15,000+ member family!

Now subscribe to Excel Trick and get a free copy of our ebook “200+ Excel Shortcuts” (printable format) to catapult your productivity.

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.

How to spell check worksheets in excel

Spell check in Excel might sound like a function that is less significant to us considering the fact that Excel is used for data organization and analysis only, so why use it anyways? However, using it in your Excel sheet might do wonders for you. One of the major benefits of using it is the accuracy that it provides to the users. Running a spell check in your worksheet will make sure that your document is free from any typos and spelling errors and it takes not more than a couple of minutes to perform.

An important thing to note here is that you can run a spell check irrespective of whether the selected text is in a cell, range, multiple sheets, or the entire workbook. Just press a few buttons and you’ll have an error-free Excel workbook!

Keep reading to learn how to enable spell check in Excel to minimize your errors as well as your efforts ( and it won’t take more than a few minutes!)

Check out How To Change Case In Excel in simple steps.

Table of Contents

Where Is Spell Checker In Excel?

Step 1: Look for the spell check option in Excel in the review tab in the ribbon.

Step 2: When you click on this spelling option, a spell check dialogue box will show.

How to spell check worksheets in excel

Keyboard Shortcut To Run Spell Check

You can spell-check in Excel using the keyboard shortcut F7 as well; to do this, you need to:

Step 1: Activate the worksheet where you want to run a spell-check.

Step 2: Select the cells and then press F7 on your keyboard.

How To Do Spell Check In Excel?

Regardless of the version of Excel you’re using, there are two primary ways through which you can spell-check in Excel. One is with the help of the ribbon button and the second is the keyboard shortcut.

To do this, select the cells you want to check spellings for and perform either of these –

    1. Press F7 on the keyboard, OR
    2. Click on the spelling button present in the review tab in the proofing group.

    These methods will perform a spelling check on the selected cells. In case of mistakes detected, a spelling dialogue box will open, and to correct these mistakes, you can choose the appropriate spelling from a list of suggestions.

    Now, when the spell check dialogue box opens, you can see a lot of buttons there and you might wonder, what are these for? Simply put, you can make use of these options when you think a mistake detected by Excel is not really a mistake according to you.

    You can also take the help of AutoCorrect and AutoComplete options in your worksheet. It will help you maintain the accuracy of your sheet by correcting spellings on the go. In addition, it can also prove to be useful when you are creating formulas in a cell. Steps to do so are:

    Step 1: Click on File and then click on options.

    Step 2: You will see an AutoCorrect option under the proofing tab. It will check your spelling errors.

    Check Individual Cells And Ranges

    A spell check can be performed in individual and multiple cells, ranges, sheets, and for the entire workbook (including headers, footers, etc.). This means that you can use the spell-check function in Excel in almost every part of the sheet.

    In Excel, when you are applying the spell check function to an individual cell, Excel automatically continues to check the rest of your worksheet and makes you spell check from the beginning. This applies when you have selected any random cell in the worksheet. On the other hand, you can ask Excel to check the whole sheet for you just by selecting the first cell in the sheet.

    However, there are times when you want to check your spellings in just a single cell, a range of cells, or a part of the text in a cell. To do so, you can double-click on the cell, enter the edit mode, and initiate the spell check. The same is the case with a range of cells where you just have to select a particular range of cells on which you want to perform a spell check and follow the same steps.

    Lastly, if you want to check just one part of the text in a cell, double click on the cell, select that part, and then run spell-check.

    Check Spelling In Selected/Multiple Sheets

    Here’s what you need to do if you want to spell-check in Excel for multiple sheets :

    Step 1: Select all the sheet tabs where you want to run a spell-check, by pressing Ctrl on your keyboard.

    Step 2: Now either directly press F7 on your keyboard or click on the Spelling button in the review tab.

    Excel will automatically check for spelling mistakes in all the selected sheets. When the spell check in Excel is done, right-click on your selected tabs and click on “Ungroup sheets”.

    Spell Check The Whole Workbook

    If you want to check spellings in the entire workbook, then right-click on any of the sheet tabs; then click on “select all sheets” from the menu hence opened.

    Now that all the sheets are selected, simply press F7 or click on the Spelling button in the review tab.

    How to spell check worksheets in excel

    Spell Check Text In A Formula

    Microsoft Excel doesn’t check for spelling errors in a cell that contains a formula and not a text. But, if you still want to do it then you can double click on the cell to get into edit mode and then run spell check on it. It will work.

    That is how you can apply spell check in Excel for different places in your worksheet to avoid all the spelling related mistakes. There are many more such tools, tips, and tricks to make working with Excel easy for you. If you want to learn them, feel free to check out the Advanced Excel Online course offered by Testbook as part of its Testbook Select initiative. Also, you can download the Testbook app from Google Playstore to get amazing deals and discounts on immersive study material, articles, and preparation tips.

    Microsoft Excel offers a basic spelling function that can help you check your spelling on any spreadsheet that you produce. This function is very limited, in relation to the spell check function in Microsoft Word or Microsoft PowerPoint. The Microsoft Word and Microsoft PowerPoint’s spell check function underlines the misspelled words as you write, while the Microsoft Excel spell check function does not. The function in Microsoft Excel will only notify you of misspelled words if you run the spellcheck feature. Also, it does not identify grammatical errors.

    How to use spell check in Microsoft Excel

    It is very easy to check your spelling within Microsoft Excel:

    1. Go to the ‘Review’ tab in the ribbon in the Excel spreadsheet.
    2. In the ‘Review’ tab, activate the option ‘Spelling’ (found on the left hand side) to spell check the worksheet (or use the shortcuts ALT > R > S or F7 to activate Spelling).

    3. Once the spell check is initiated, a Spell Check dialogue box will appear (shown below).

    How to spell check worksheets in excel

    It is really important to understand the different options available in this dialogue box. Here are brief definitions of each of the available options:

    Ignore Once: This option allows you to disregard a spell check error suggestion for a word once.
    Ignore All: This option allows you to disregard a spell check error suggestion for a word indefinitely on the spreadsheet.
    Add: This option allows you to add a word that spell check regards as an error to the Microsoft Excel dictionary, as long as the word is used correctly. This will make the word acceptable within Microsoft Excel and will no longer be deemed as a spell check error.
    Change: This option allows you to select a suggestion for a spell check error in order to automatically correct the misspelled word. There may be more than one suggestion for the misspelt word. Select the suggestion that you would like to apply.
    Change All: This option allows you to change all of the spell check errors that apply to the same misspelled word with the selected suggestion of your choice.

    AutoCorrect: This option changes a misspelled word with your selected suggestion and adds it to the autocorrect list. This allows excel to automatically correct that same misspelled word to the selected suggestion.

    How to spell check worksheets in excel

    The Spell Check dialogue box shows you suggestions to misspelled words. Clicking the ‘Change’ button will automatically correct the spelling.

    How to spell check worksheets in excel

    You can also disregard the suggestions provided to you by simply clicking ‘Ignore Once’ or ‘Ignore All’ button.
    Once the spell check is complete, an alert will notify you:

    Keyboard Shortcuts to Spell Check in Microsoft Excel

    Press F7 to initiate the spell check feature. Alternatively, you can use the ALT Shortcut Alt > R > S.

    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.

    Kasper Langmann, Co-founder of Spreadsheeto

    *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:

    Kasper Langmann, Co-founder of Spreadsheeto