HomeApplicationOffice information

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!

4 ★ | 1 Vote
Spell Checkcheck spellingmisspellingsspreadsheetsOffice ExcelExcel 2016Microsoft OfficeMicrosoft Office 2016familiarize yourself with ExcelMicrosoft accountguide excel 2016excel tips 2016learn excel 2016text format

You should read it

May be interested

  • Complete guide to Excel 2016 (Part 10): Use the Find and Replace functionComplete guide to Excel 2016 (Part 10): Use the Find and Replace function
    when working with a lot of data in excel 2016, you may find it difficult and time-consuming to determine the specific location of the information.
  • Lock one or more data columns on Excel worksheet - Freeze data in ExcelLock one or more data columns on Excel worksheet - Freeze data in Excel
    to lock one or more data columns in excel worksheet, you do as follows: open the sheet containing the data columns to be locked, then select all sheets by pressing ctrl + a. right-click and choose format cells ...
  • A complete guide to Excel 2016 (Part 14): Create complex formulasA complete guide to Excel 2016 (Part 14): Create complex formulas
    after learning about the recipe in excel 2016, tipsmake.com continues to guide you how to create more complex formulas. invite you to consult!
  • Perform printing in ExcelPerform printing in Excel
    guide you to perform printing in excel. after setting up the page to print the final step, you can manipulate to print the worksheet in excel. step 1: after setting up the worksheet - click file - print: step 2: the print window appears in pa section
  • How to Insert a Page Break in an Excel WorksheetHow to Insert a Page Break in an Excel Worksheet
    if you've ever tried printing a large microsoft excel worksheet, you've undoubtedly encountered some awkward-looking print jobs. excel's automatic page breaks don't exactly take your custom data views into consideration. in order to...
  • How to turn off spell check mode in Windows 10?How to turn off spell check mode in Windows 10?
    windows 10 as well as the microsoft office suite, now has the function to automatically correct spelling, grammar ... when users type in the system. but for many people, this is a feature that causes trouble, unnecessary. so what to do to remove this automatic spell check feature?
  • Change the slash to a dot in Excel formatChange the slash to a dot in Excel format
    by default, the excel date format often uses slashes, such as march 23, 2016 .... however, if your worksheet has multiple dates lists, you can use dots. in date format to make the worksheet easier to see, no glitches.
  • How to Clear Filters in ExcelHow to Clear Filters in Excel
    this wikihow teaches you how to remove data filters from a column or an entire worksheet in microsoft excel. open your spreadsheet in excel. you can do this by double-clicking the file on your computer.
  • A complete guide to Excel 2016 (Part 4): How to store and share spreadsheetsA complete guide to Excel 2016 (Part 4): How to store and share spreadsheets
    whenever you create a new spreadsheet in excel, you need to know how to save to access and edit later. like previous versions of excel, you can save local files to your computer.
  • How to spell check in Linux TerminalHow to spell check in Linux Terminal
    linux also has a command line spell checker utility in terminal. the utility is called aspell and is installed by default on ubuntu. this is how you can use aspell to check spelling in a terminal.

Office information