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

  • 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 ...
  • Getting Started with Excel 2016 ntroduction Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may believe Excel is only used by certain people to p ...
  • Using Find & Replace Excel 2016 Introduction When working with a lot of data in Excel, it can be difficult and time consuming to locate specific information. You can easily search your workbook usi ...
  • 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 ...
  • 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 ...