Spell check is a tool in Excel that verifies the spelling of words and highlights any errors. Although Microsoft Excel is not a word processing program, it does include some text-editing features, such as spell-checking.
How to do spell check in excel?
By following a few simple steps, we can spell check in the Excel.
Step 1: Select the cells to spell-check.
Step 2: Click Spelling on the Review tab, under the Proofing group. The Spell Check dialog box opens.
Step 3: To correct a mistake, select an appropriate option from Suggestions and click the Change button.
Step 4: When the spell check is completed, Excel will display the corresponding message. Click OK.
Keyboard Shortcut to Run Spell Check in Excel
Simply choose the cell from which you want to begin checking, and then on your keyboard, press the F7 key.
Features of Spell Check Window in Excel / Understanding the Spell Check Dialogue Box:
When we run spell check in Excel, a Spell Check dialogue window with certain options appears. The spell check dialog box looks like this:
We have the following options in the image above:
Ignore Once: If we want to keep the selected cell unchanged and move the cursor to the next cell of the matching word, we must click the ‘Ignore Once’ button.
Ignore All: Once Excel detects and marks a specific term as an error, and the word appears numerous times inside the sheet, yet you wish to retain all of the instances the same, then must click the ‘Ignore All’ box.
Add to Dictionary: Click ‘Add to Dictionary’ to add the current word to the dictionary. This ensures that the same term is not recognized as an error the next time you spell check.
Change: When you select this option, the suggested word replaces the misspelled word.
Change All: Click ‘Change All’ to replace all mistakes similar to the current one with the selected suggestion.
AutoCorrect: Click ‘AutoCorrect’ to let Excel rectify the error as it sees fit. If you type the same misspelled word again, Excel will automatically convert it to the suggestion you choose.
Not in dictionary: It displays the spelling mistake that does not exist in the Excel dictionary.
Suggestions: When Excel discovers incorrect or wrong spellings, it displays several relevant ones as replacements in the ‘Suggestions’ section. You can choose any of the terms from the list.
Dictionary Language: Using this drop down, you may change the dictionary language.
Options…: Click the ‘Options…’ button to view or adjust the spell check settings.
Cancel: Click the ‘Cancel’ button to end the correction procedure and close the dialog.
How to AutoCorrect in Excel?
Excel AutoCorrect is intended to automatically fix misspelled words as you type.
The following are the steps for customizing the AutoCorrect feature:
Step 1: On the Excel ribbon, select the File tab.
Step 2: Tap on the “Options.”
Step 3: Click Proofing in the Excel Options dialog box.
Step 4: Select ‘Autocorrect Options’ from the Proofing menu.
Step 5: The “AutoCorrect” dialog box appears.
Step 6: Fill in the “replace” box with the words that need to be replaced. And type the correct words in the ‘With’ box.
Excel is asked to replace faulty spellings (in the “replace” box) with proper spellings (in the “with” box).
Please keep in mind that the “AutoCorrect” panel already displays the most common misspellings and associated corrections that are utilized by default. This list’s entries can be changed, added to, or deleted.
Understanding the Autocorrect Options Tab:
Some options in the Autocorrect Options tab are enabled by default and solve some frequent issues.
We have the following options in the image above:
Show Autocorrect Options buttons: This one isn’t applicable to Excel, but it is for other Microsoft products. When you enable this option, the autocorrect options in MS Word or MS PowerPoint appear.
Correct two initial capitals: Lowercases the second capital letter. Example, when you type ‘APple,’ this will convert into ‘Apple,’ automatically.
Capitalize first letter of sentences: After a period (full stop), capitalizes the first letter. Example, when you type ‘Apple. orange.’ this will convert into ‘Apple. Orange.’ automatically.
Capitalize names of days: Change the first letter of the day name. Example, friday will convert into ‘Friday.’ automatically.
Correct accidental use of Caps lock key: Fixes words with the initial letter in lowercase and the others in uppercase. Example, ‘aPPle’ will convert into ‘Apple.’ automatically.
Replace text as you type: Excel already includes several often-misspelled words here. When you type (e), for example, it is instantly turned into ‘€’. This is due to it being listed in the list in this option. You get the option of adding or removing words from the list.
You may be interested: