Whenever you share your workbook with others you need to always make sure that there are no spelling errors. MS Excel 2016 has got Spell Check tool which can be used for making sure that everything typed into your worksheet is spelled correctly. The Spell Check tool in MS Excel is not as powerful as it is in MS Word i.e. this tool can not check the grammatical errors as well as spelling as you type. You can also learn Freezing Panes in a Worksheet in MS Excel 2016. In order to use the Spell Check tool you need to follow these simple steps.
- 1st of all you need to click the Spelling command from the Review tab.
- The Spelling dialog box will appear and for every error in your worksheet Spell Check will offer you various suggestions for correct spelling. You need to select the suggestion and click Change for correcting the error.
- A dialog box will appear after reviewing all spelling errors. Now click on OK to close the Spell Check.
Ignoring Spelling Errors:
The Spell Check is not necessarily always correct and sometimes it will mark certain words as incorrect even of they are spelled correctly. This issue will happen with the names which may not be included in dictionary. You can select not to change a spelling error using one of the following three options:
Ignore Once: This option will skip the word without changing it.
Ignore All: This option will skip the word without changing it and also skip all other instances of the word in your worksheet.
Add: This option will add the word to the dictionary so that it will never appear as an error while you type it in your worksheet.