Excel 2016 - Lesson 11: Check spelling in Excel spreadsheets

  1. Excel 2016 (Part 8): Understanding Number Formats
  2. Excel 2016 (Part 9): Working with multiple spreadsheets
  3. Excel 2016 (Part 10): Using Find and Replace

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

 

If you've used the spell check feature in Microsoft Word , you should be aware that the spell check tool in Excel is helpful, but not "powerful." For example, it won't check for grammar issues or check spelling as you type.

Let's refer to the instructions for checking spelling on Excel 2016 spreadsheets in this article with TipsMake.com!

Using Spell Check in Excel 2016

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

Excel 2016 - Lesson 11: Check spelling in Excel spreadsheets Picture 1

2. The Spelling dialog box appears. For each spelling error in your spreadsheet, Spell Check offers a suggestion for the correct spelling. Select a suggestion, then click Change to correct the error.

Excel 2016 - Lesson 11: Check spelling in Excel spreadsheets Picture 2

 

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

Excel 2016 - Lesson 11: Check spelling in Excel spreadsheets Picture 3

If there are no suitable suggestions, you can retype the spelling yourself.

Ignore spelling "mistakes"

Spell Check isn't always accurate. Sometimes certain words are marked as incorrect, even when they're completely correct. This often happens with proper names, which aren't in the dictionary. You can choose not to change spelling 'errors' by using one of the following three options:

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

Next Excel 2016 lesson: Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets

Have fun!

4 ★ | 2 Vote

May be interested