Spell Check In Excel

Last Updated :

-

Blog Author :

Jeevan A Y

Edited by :

Vandana Kataria

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

What Is Spell Check In Excel?

Spell Check in Excel is a method to detect spelling errors in the text strings in an Excel workbook. Unlike MS Word and PowerPoint, Excel does not underline a misspelled word which results in spelling mistakes.

Excel Spell Check is beneficial when working with databases containing a mix of numbers and text.

For example, the cell references and text strings of a worksheet are listed as follows:

  • Cell A1 consists of “Garden”.
  • Cell A2 consists of “Kitchne”.
  • Cell A3 consists of “Bulding”.
  • Cell A4 consists of “Garage”.

On running a Spell Check, the “spelling” window opens. It shows the suggestions or the right spellings of the misspelled words such as “kitchen” and “building”. Clicking “change” replaces the misspelled words (in cells A2 and A3) with the suggested options.

As shown in the image below, the shortcut (F7) or pressing the “spelling” button (under the Review tab) opens the “spelling” window.

Spell Check In Excel - Review
Table of contents
  • The Spell Check in Excel helps users deliver an error-free Excel workbook, and ensures that the text is in accordance with the current proofing language.
  • We can use the shortcut key F7 or the Review Tab to perform spell check for the Excel workbook.
  • In Excel Spell Check, we have multiple options, such as,
    • Ignore, Ignore All - To leave the misspelled words as it is.
    • Change, Change All - To replace the misspelled words with the required text.
    • AutoCorrect – To set some words to get automatically adjusted to the right spellings, and
    • Add to dictionary – To add new words such as frequently used abbreviations, acronyms, names of people, etc.

How Spell Check In Excel Works?

Let us understand the working of the Excel Spell Check by assuming that the range A1:A10 consists of text strings. The user can select any of the following options as the starting point:

  • Select cell A1 – Excel checks the entire worksheet for spelling errors.
  • Select cell A5 (or any other cell) – Excel checks for spelling errors beginning from cell A5 till the last data cell. Once it completes the Spell Check, a message asks whether to continue checking at the beginning of the sheet or not. The user is presented with the following options:

a. Yes – If this is clicked, Excel resumes checking from cell A1 and stops at cell A5.

b. No – If this is clicked, Excel stops checking at that point (last data cell of the worksheet).

How To Perform Spell Check In Excel?

In Excel, Spell Check in Excel is carried out either by,

  • Pressing the shortcut F7.
  • Enabling AutoCorrect.
  • Pressing the “spelling” option from the Review tab.

For example, the following image shows the data of a worksheet. The spelling errors have been highlighted in bold. We will run a Spell Check in Excel using the shortcut key F7.

Let us assume that the cell A1 is the starting point.

spell check in excel example 1

The steps to apply Spell Check are as follows:

Step 1: Select cell A1 and press F7.

  • The “spelling” dialog box opens, as shown in the succeeding image. The spelling “mostt” is “not in dictionary”. The suggested spelling is “most”.
  • To accept the suggestion, click “change”. To ignore the suggestion, click “ignore once”.

spell check in excel example 1-1

Step 2: Once an option is selected, the next spelling mistake gets displayed. The spelling “pwerful” is incorrect and “not in dictionary”. The suggested spelling is “powerful”.

Click “change” to replace the incorrect spelling with the correct one. Otherwise, click “ignore once” to retain the incorrect spelling as is.

spell check in excel example 1-2

Likewise, the Spell Check continues till the last data cell of the worksheet.

The Spell Check Window In Excel

The “spelling” dialog box is shown in the following image. Let us understand the functions of the options present on the left side of this window.

spell check in excel example 1-3

Not in dictionary: It shows the misspelled word, which is not there in the Excel dictionary. Excel recognizes this word as a spelling mistake.

spell check in excel example 1-4

Suggestions: It displays one or more words that are similar in spelling to the misspelled word. These words are the corrections suggested by Excel.

spell check in excel example 1-5

Dictionary language: It is the selected language, which is adhered to while checking for misspelled words.

spell check in excel example 1-6

Let us understand the functions of the various options on the right side of the “spelling” window. These options are shown with serial numbers in the following image.

spell check in excel example 1-7

The options are explained as follows:

  1. Ignore once: Clicking this option ignores the current error. So, the misspelled word remains as is.
  2. Ignore all: With this option, all the instances of the misspelled word are ignored. So, all occurrences of the misspelled word remain as is.
  3. Add to the dictionary: It adds the current word to the dictionary. Henceforth, Excel will not identify this word as an error. This option should be used if the spelling is correct, but is not present in the dictionary. For instance, an abbreviation or a person’s name can be added to the dictionary.
  4. Change: Clicking this option replaces the misspelled word with the suggested word. One can choose from the suggestions listed in the “spelling” window.
  5. Change all: This replaces all the instances of the misspelled word with the suggested word. Before clicking this option, one can select from the available suggestions.
  6. AutoCorrect: Clicking this option adds the misspelled word and the selected suggestion to the AutoCorrect list. Henceforth, if the same incorrect spelling is typed, Excel will auto-correct it. For example, the misspelled word is “nned” and the suggested word is “need”. With AutoCorrect, every time “nned” is typed, it will automatically be converted to “need”. We will have noticed some words such as “AND” & “THE” autocorrected when mistyped.
  7. Cancel: Clicking this option stops the Spell Check process and closes the “spelling” window. It can be clicked at any point.

The AutoCorrect In Excel

One can enable, disable, or customize the AutoCorrect feature in Excel.

The steps to customize the AutoCorrect feature are listed as follows:

  1. Click the File tab on the Excel ribbon.


    step 1

  2. Click “options.”


    step 1-1

  3. The “Excel options” window opens. Click “proofing.”


    step 1-2

  4. Click “AutoCorrect options.”


    step 1-3

  5. The “AutoCorrect” window appears, as shown in the succeeding image.

    In the box under “replace,” type the words which need to be replaced. Type the replacements (corrections) in the box under “with.”

    In other words, Excel is being told to replace the incorrect spellings (in the “replace” box) with the correct ones (in the “with” box).

    Hence, the AutoCorrect feature can be customized as per the requirements of the user.


    step 1-4

The Features Of The Spell Check In Excel

The features of the Excel Spell Check are listed as follows:

  • It ignores the uppercase values. For example, if the word is “KITCHNE”, Excel does not recognize this as an error.
  • Unlike MS Word, it does not correct grammatical errors.
  • The default settings of the Spell Check can be changed by selecting “proofing” from “options” under the File tab.
  • It does not recognize a text string containing a number (in one cell) as an error. For example, if the word is “KITCHNE1”, it is not identified as an error.
  • It identifies repeated words as errors. For example, in the string “this is the the kitchen,” the extra “the” is pointed as an error.

Important Things To Note

  • If there are no spelling errors in the worksheet, the “spelling” window will not open. To change the dictionary language in such cases, misspell a word intentionally. In this way, the “spelling” window is made to appear.
  • The “AutoCorrect” window already lists the typical misspellings and their corrections that are used by default. We can change, add, or delete entries from this list.

Frequently Asked Questions (FAQs)

1. Where is the Spell Check in Excel?

Spell Check helps check the spelling entered in the Excel worksheet, and users can be assured that there are no spelling errors in the text strings.
The Excel Spell Check is found in the Review tab, and we can use it by clicking “spelling” in the “proofing” group, as shown below.

The shortcut key for Excel Spell Check is F7.

2. How to run a spell check on the entire workbook of Excel?

The steps to perform a spell check on the entire workbook are listed as follows:

a) Right-click any sheet tab at the bottom-left side of Excel.
b) Choose “Select all sheets” from the context menu to select all the workbook sheets.
c) Press F7, or click “spelling” from the “proofing” group of the Review tab.

Excel runs a Spell Check on all the worksheets of the current workbook. If there are any spelling errors (in any worksheet), the “spelling” window appears.

At the end of the process, Excel displays a message confirming that the Spell Check is complete.

3. How to change the dictionary language used in the spell check process of Excel?

The steps to change the dictionary language in Excel are listed as follows:

a. Click “spelling” in the “proofing” group of the Review tab.
b. The “spelling” window opens. Choose the desired language from the “dictionary language” drop-down.
c. Click “Cancel” to close the “spelling” window.
d. Click “spelling” again from the Review tab. Excel begins the Spell Check with the newly selected language.

Hence, the dictionary language is changed.

Download Template

This article must help understand Spell Check in Excel with its formulas and examples. You can download the template here to use it instantly.

Spell-Check-Excel-TemplateDownload