Watch the Video Tutorial – Spell Check in Excel Show Spell Check in Excel is often ignored given that Excel users often work with numbers as compared with text. But it is still one of the important checks one should have in place. As compared to MS Word or PowerPoint, where you can visually see a red underline below the word that has been misspelled, nothing of that sorts happen in Excel. Imagine a disastrous spelling error glaring out of your worksheet when you sent it to your client. No matter how much hard work you put into data crunching and analysis, all your credibility goes down the drain. Well – NOT anymore. In this tutorial, I will show you how to use spell check in Excel and how you can maximize your efforts by the options available to you. Where to find Spell Check in ExcelYou can find spell check option in review tab in the ribbon in Excel. When you click on the Spelling option in the review tab, it opens the Spell Check dialogue box. Keyboard Shortcut to Run Spell Check in ExcelYou can also use the keyboard shortcut F7 to run spell Check in Excel. To use this, activate the worksheet in which you want to run spell check, select the cell/range of cells, and press F7 from your keyboard. How Does Spell Check Works in ExcelAn important thing worth knowing is how spell check in Excel works. If you select cell A1, it will go through all the cells in the first row, then moves to the second row and check all the cells in the second row (from left to right) and then move to the third row and so on. If it identifies a cell with a spelling error, it displays the Spelling dialogue box. If you select a cell somewhere else in the worksheet, let’s say B3, then it will go through the cells to the right and then to the row below it. When it is done with checking for all the cells after B3, it will show a prompt that asks the user if he wants to continue checking at the beginning of the sheet. Something as shown below: If the user selects Yes, it goes back and checks the remaining cells (which would be A1 to B2 in our example). To get a better understanding, have a look at this example below (cell shaded are the ones with a spelling error): As shown, when we begin the spell check with A1, it completes the spell check for all the cells. But when we begin with cell B3, it checks for all the cells from B3 and then asks the user if he/she wants to continue checking from the beginning. Understanding the Spell Check Dialogue BoxWhenever you run spell check in excel and it finds an error, it shows the Spell check dialogue box (as shown below): Let’s quickly understand the different options available in the spell check dialogue box:
Here are some default settings in Spell Check in Excel:
You can change these default setting by clicking on the ‘Option’ button in the Spell Check Dialogue box. It will open the Options dialogue box where you can make the necessary changes. Hope you found this tutorial helpful. Let me know your thoughts by leaving a comment below. You May Also Like the Following Excel Tutorials:
Does the spelling checker catch all spelling mistakes?Answer. No, spell check does not catch every spelling error.
Which tool is used to find and correct mistakes in your spelling?Grammarly
The suggestion tool allows finding mistakes and choosing the correct spelling of a particular word.
What CTRL is spell check?Open the document you want to check for spelling or grammar mistakes, and then press F7. You can also use the ribbon to start the check. Press Alt+R to open the Review tab, and then press C, 1 to select the Check Document option.
What will you use to check the spelling of words?On the Word menu, click Preferences > Spelling & Grammar. In the Spelling & Grammar dialog box, under Spelling, check or clear the Check spelling as you type box. Under Grammar, check or clear the Check grammar as you type box. Close the dialog box to save your changes.
|