Checking Spelling Excel 2016

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors. Fortunately, Excel includes a Spell Check tool you can use to make sure everything in your workbook is spelled correctly.
If you've used the Spell Check feature in Microsoft Word, just be aware that the Spell Check tool in Excel, while helpful, is not as powerful. For example, it won't check for grammar issues or check spelling as you type.
Optional: Download our practice workbook.

To use Spell Check:

  1. From the Review tab, click the Spelling command.
    Selecting the spelling command
  2. The Spelling dialog box will appear. For each spelling error in your worksheet, Spell Check will try to offer suggestions for the correct spelling. Choose a suggestion, then click Change to correct the error.
    Clicking change to correct a spelling error
  3. A dialog box will appear after reviewing all spelling errors. Click OK to close Spell Check.
    Clicking ok to close spell check
If there are no appropriate suggestions, you can also enter the correct spelling manually.

Ignoring spelling "errors"

Spell Check isn't always correct. It will sometimes mark certain words as incorrect even if they're spelled correctly. This often happens with names, which may not be in the dictionary. You can choose not to change a spelling "error" using one of the following three options:
  • Ignore Once: This will skip the word without changing it.
  • Ignore All: This will skip the word without changing it and also skip all other instances of the word in your worksheet.
  • Add: This adds the word to the dictionary so it will never appear as an error again. Make sure the word is spelled correctly before choosing this option.

Related : Checking Spelling Excel 2016

  • Intro to Formulas Excel 2016 Introduction One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtra ...
  • Relative and Absolute Cell References Excel 2016 Introduction There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. ...
  • Modifying Columns, Rows, and Cells Excel 2016 Introduction By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in differen ...
  • Working with Multiple Worksheets Excel 2016 Introduction Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize y ...
  • Page Layout and Printing Excel 2016 Introduction There may be times when you want to print a workbook to view and share your data offline. Once you've chosen your page layout settings, it's easy to previ ...