Spell Check in Excel
MS Excel is one of the most powerful programs that help us record data within the rows and columns in spreadsheets. It allows us to store vast amounts amount of data and perform different data-centric operations on it.
Since we typically enter the data with the help of a keyboard, there are chances that we mistype some spellings. For this, Excel provides us a built-in tool to find and correct the wrong or mistyped spellings with ease. The tool is usually known as the 'Spell Check' and 'Spell Checker'. However, the Spell Check tool in Excel is not as powerful as Word Spell Check as it does not check grammatical errors or check spellings as soon as we start typing. In excel, we must check and correct spellings manually.
In this article, we are discussing the detailed introduction of Spell Check in Excel. The article also discusses the steps to help us understand how we can spell check within the Excel worksheet and increase the overall productivity, making our work effective.
What is a Spell Check?
Spell check is a software tool that helps us find the wrong spelling of words and correct them. The tool is typically helpful for various word processing programs, emails, data entries, cell phone messaging, blog posting, and more. A good spell-check tool automatically finds the misspelled words within the entire document and gives us relevant suggestions to correct them. Some tools even automatically correct the misspelled words.
The spell-check tools can be built-in with the specific programs as well as come in as standalone software. However, the most common thing is that they all usually underline the errors with red color. Furthermore, a menu with correctly spelled suggestions is also displayed, enabling us to choose the correct spelling or ignore it.
Where do we find Spell Check in Excel?
In Excel, the spell-check tool is located under the 'Review' tab in the ribbon. It is identified by the text 'Spelling' associated with the tile that has 'ABC' written on it. It looks like the following image:
Every time we click on the spell-check tool from under the Review tab, it launches the 'Spell Check Dialogue Box', as shown below:
Note: Although we can perform a spell check in Excel in different ways, the easiest one is to use a shortcut key. Excel allows to immediately perform spell check within the entire sheet by pressing the function key 'F7' on the keyboard. However, it must be noted that we may first need to activate the function keys by pressing the 'Fn' button on the keyboard.
How does Spell Check work?
We must understand the process of how the spell-check tool works in Excel. Suppose we select cell A1 and run the spell check within the entire sheet. The tool will analyze cell A1 and then the others cells in the first row. After that, it will move onto the second row and check all the cells from left to right, then the third row, and so on. If the tool finds any spelling error in any of the cells, it displays the Spell Check dialogue box with various options.
Apart from this, if we select the cell somewhere else within the sheet and run the spell-check tool, the tool starts checking for errors from that particular point. For example, if we select cell B2 and run spell check, it will go through all the cells in the second row from the B2 cell and then the other rows. Every time we start from a cell somewhere else in the sheet, it asks us whether we want to continue checking for spelling mistakes at the beginning of the sheet after checking the rest of the cells after selection.
Understanding the Spell Check Dialogue Box Interface
When we run spell check in Excel, it displays a Spell Check dialogue window with some options. The spell check dialogue window typically looks like this:
In the above image, we have the following options:
Adjusting Spell Check Settings
Excel spell-check tool has some default configurations or options that help control how Excel connects and formats our data. We can change these default settings by clicking on the 'Options' button in the Spell Check Dialogue box. It will open the Options dialogue box to help us make the necessary changes in spell check by navigating to the Proofing menu.
The following are some default presents for spell check in Excel:
Steps to Spell Check Individual Cells and Ranges in Excel
Sometimes, we may have some names or acronyms within the cells that may not be needed to check for spelling errors. However, we may need to spell check for the remaining individual cell or the multiple cells in a range.
For Individual Cells
If we have doubts regarding spelling mistakes in a single cell, we can perform a spell check only for a corresponding cell.
Suppose we have the following data set where we have some doubts regarding the spelling written in cell A2.
We need to follow the steps discussed below to spell check in any cell within the sheet:
If we have doubts regarding spelling mistakes in multiple cells, we can perform a spell check for multiple cells.
Suppose we have the following data set where we have some doubts regarding the spellings in columns C and D.
We need to follow the steps discussed below to spell check multiple cells in a range within the sheet:
Steps to Spell Check Selected Sheets in Excel
If we have data in multiple sheets within the workbook and we want to perform a spell check in some individual sheets only, we need to follow the below steps:
Steps to Spell Check Entire Workbook in Excel
Excel also allows us to check spelling mistakes within the entire workbook/ spreadsheet at once. This will cover all the sheets of the active workbook. For this, we need to follow the below steps:
That is how we can use the spell-check tool in Excel.