To stop the correction process and close the dialog, click the Cancel button.To view or change the spell check settings, click the Options… button.To set another proofing language, select it from the Dictionary language drop box.To let Excel correct the mistake as it sees fit, click AutoCorrect.To replace all the mistakes same as the current one with the selected suggestion, click Change All.This will ensure that the same word won't be treated as a mistake when you do a spell check next time. To add the current word to dictionary, click Add to Dictionary.To ignore all the mistakes same as the current one, click Ignore All.To ignore the current mistake, click Ignore Once.

If the 'mistake' is not really a mistake, pick one of the following options: The misspelt word will be replaced with the selected one and the next mistake will be brought to your attention. To correct a mistake, choose an appropriate opting under Suggestions, and click the Change button. When a mistake is found, the Spelling dialog window shows up: This will perform a spelling check on the active worksheet:

Click the Spelling button on the Review tab, in the Proofing group.

Simply, select the first cell or the cell from which you'd like to start checking, and do one of the following: No matter which version you are using, Excel 2016, Excel 2013, Excel 2010 or lower, there are 2 ways to spell check in Excel: a ribbon button and a keyboard shortcut.

Find typos and misprints with Fuzzy Duplicate Finder.

But still Excel provides the basic spell checking functionality and this tutorial will teach you how to get most of it. It does not offer advanced capabilities like grammar checking, nor does it underline the misspelled words as you type. However, spell check in Excel is not exactly the same as in Word. You will learn how to check spelling in individual cells and ranges, active worksheet and the entire workbook.Īlthough Microsoft Excel is not a word processing program, it does have a few features to work with text, including the spell-checking facility.

The tutorial shows how to perform spell check in Excel manually, with VBA code, and by using a special tool.

How to spell check on mac pages