QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Spell Check in Excel?

By Neha T Leave a Comment

In excel we don’t write text in sentences or paragraph. The main motive of using excel is to store data or information in tabular form so there is not much need for spell check in excel. Sometimes people even forget to check spellings in excel.

The spell check in excel is not similar to spell check of MS Word. Excel never highlight the incorrect spelling by underlining it with the red wavy underline. Excel does not even go for grammar checking. But, it still provides a basic spelling checking facility for the users.

In this section, we will discuss the steps for checking spellings of a sheet in excel. We will also study the method to check the spelling of a particular cell or a specified range of cells.

Steps to Spell Check in Excel 2016:

Step 1: Open the Excel worksheet and click on the ‘first’ cell of your sheet.

Spell Check in Excel - 1

Step 2: Go to the Review tab and under Proofing group click on ‘ABC Spelling‘.

Spell Check in Excel - 2

Step 3: As soon as you click on ‘ABC Spelling’, a Spelling dialog box will pop up and the ‘first misspelt word’ of the worksheet will get selected automatically.

Spell Check in Excel - 3

The first text box (Not in Dictionary) of the Spelling dialog box shows the misspelt word of the selected cell. Like in the image below, you can observe that the selected cell has two words ‘Sweet Ornges’ among which only the spelling of ‘Ornges’ is misspelt. So, ‘Not in Dictionary’ text box only shows ‘Ornges’.

In the ‘Suggestions’ section of the Spelling dialog box, some correct spellings are suggested for the misspelt word.

You can change the spelling by clicking on the ‘Change’ button.

Well, there several buttons in the Spelling dialog box let us discuss them all at once:

Ignore Once: Using this button you can ignore the currently selected misspelt word.

Ignore All: Using this button you can ignore all the misspelt words which are exactly same as the currently selected misspelt word.

Add to Dictionary: Using this button you can add the currently selected misspelt word to the dictionary. This will avoid considering it again as a misspelt word.

Change: For using this button, first select the correct spelling according to you from the Suggestions section, and using this button you can replace the currently selected misspelt word to the correct one.

Change All: First, select the correct spelling from the suggestions section and using this button you can replace all the misspelt word which are exactly same as the currently selected misspelt word.

AutoCorrect: Using this button you allow excel to correct the spelling on its own.

Options: This button leads you to the spell check setting section.

Undo Last: Using this button you can reverse your last move.

Cancel: Using this button you can stop the Spell check process.

After the correction of the first misspelt word Spelling dialog box will take to the ‘next misspelt word’ of the sheet. Like in the image below, the next selected misspelt word is ‘Licchis’.

Spell Check in Excel - 4

After correcting misspelt word ‘Licchis’ the next selected misspelt word is ‘Grpes’. Like this, after every correction, the next misspelt word would be selected until all the misspelt words are processed.

Spell Check in Excel - 5

After the process of spell check is done for the entire sheet a Microsoft Excel dialog box will pop up delivering the message ‘Spell check complete. You’re good to go!’ Click OK to finish spell check.

Spell Check in Excel - 7

Note: If you don’t want to investigate the entire worksheet for spell check and want to check only a particular cell, or a range of cell for spelling then:

Particular Cell: Click on the particular cell and initiate the Spell check.

Range of Cells: Select the range of cells for which you want to run spell-check and then initiate the process of spell-check.

So, this was all about the process of spell check in Excel. Hope the content is useful. Keep reading.

You Might Also Like:

Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? Hide Formula in Excel - feature imageHow to Hide Formula in Excel? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? Create a named range in Excel feature imageHow to Create Named Range in Excel? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016? how-to-create-links-in-ms-excel-2016-featured-imageHow to create Links in MS Excel 2016? How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to track Snapdeal order
  • How to Create or Delete Bookmark in MS Word 2016?
  • How to add screensavers in Ubuntu 14.04
  • How to Set Alarms, Stopwatch, World Clock and Timers in Windows 10
  • How to Restore Windows 7 to a Previous State / Particular date

Copyright © 2023 · QueHow · Contact Us