Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet

1. Guide to full Excel 2016 (Part 8): Learn about Number Formats
2. Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
3. Complete guide to Excel 2016 (Part 10): Use the Find and Replace function

Before sharing a spreadsheet, you need to make sure it doesn't have any spelling errors. Fortunately, Excel 2016 includes a Spell Check tool you can use to make sure everything in your spreadsheet file is written correctly.

If you used the spell check feature in Microsoft Word, you should note that Excel's spell checker is useful, not "powerful". For example, it will not check grammar issues or check spelling when you enter text.

Let's TipsMake.com refer to the spell check tutorial on Excel 2016 worksheet in this article!

Use Spell Check in Excel 2016

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

Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet Picture 1

2. The Spelling dialog box will appear. With each spelling error in the spreadsheet, Spell Check will provide accurate spelling suggestions. Select the proposal, then click Change to fix the error.

Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet Picture 2

3. A dialog box will appear after reviewing all spelling errors. Click OK to close Spell Check.

Complete guide to Excel 2016 (Part 11): Check spelling in the worksheet Picture 3

1. If there are no appropriate suggestions, you can manually re-enter them for correct spelling.

Ignore "spelling" errors

Spell Check is not always accurate. Sometimes certain words are marked incorrectly, even if they are completely correct. This usually happens with a unique name, not in the dictionary. You can choose not to change the spelling 'error' by using one of the following three options:

1. Ignore Once : Ignore the word without changing.
2. Ignore All : Ignore the word without changing and ignore all other spelling errors in your spreadsheet.
3. Add : This will add the word to the dictionary so that it never appears as an error again. Make sure the word is spelled correctly before selecting this option.

Refer to some of the older Excel 2016 articles:

1. A complete guide to Excel 2016 (Part 4): How to store and share spreadsheets
2. Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
3. Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells

The next Excel 2016 article: A complete guide to Excel 2016 (Part 12): Page formatting and spreadsheet printing

Having fun!