Microsoft Excel is the best and preferred program making lists, registers and forms, All of this is due to the large number of tools we have available, and if that’s not enough, it’s possible to further enhance it. You can download Excel from its official Microsoft website or buy a digital disk.
While its functionality is not as focused on writing as Microsoft Word, it is also possible to correct the spelling of words we write in its spreadsheets, and we’ll teach you how to do that in this article.
What should I pay attention to when using spell check in Excel?
Spreadsheets can be easily created in Microsoft Excel for many of the functions already mentioned, or Create a chart from the provided data And make simple and complex math accounts, the program’s other specializations; given that, their role in grammar, spelling, writing, etc. is not fully focused.
For this reason, when we accidentally write a misspelled word, Excel doesn’t mark it with the typical red underline or any other markup like Word and PowerPoint. This makes it easier for us to miss these spelling mistakes, thus forcing us to always check our spreadsheets, luckily the program has a feature to correct this.
Another point to remember is that Excel checks all text by default Found in spreadsheets: words typed in cells, words typed in inserted text boxes, graphic text, headers and footers; so if we want to check for a specific thing, we have to select or shade the problem Area.
How do I access the spell checker in a spreadsheet?
most obvious way Correct spelling mistakes It’s done manually, not the way Word does it, but by erasing and rewriting misspelled words. Another way is to use the Excel wizard, although it won’t flag what misspellings are, it will recognize them and give you some suggestions to choose from.
- With everything ready in the spreadsheet, stand on one of the boxes with text.
- Next, go to the «Check» tab and immediately see the «Spelling» option.
- Clicking on that option will open a dialog with two sections: in the upper section, it will flag misspelled words, and in the lower section, suggestions.
- To correct, just click AutoCorrect.
When you do this, The word will be checked automatically Excel will then jump to the next most misspelled word, and keep doing this until you’re all done. This method works for everything written in the spreadsheet: Another method is as follows:
- In File, go to the Options option.
- Then select the Comments category and click AutoCorrect Options.
This will still check for spelling errors in Excel, but is more limited as it will ignore inserted text boxes. From the same File menu, you can configure the Print Area in your spreadsheet.
How can you correct text as you type it in Excel?
Usually when you make the first Spell check words in Excel, It will automatically start checking all other misspelled words in real time for you. Another way is to activate this feature from scratch by going to File > Options > Review > AutoCorrect Options.
Why doesn’t Excel correct capitalized words and how to fix it?
Microsoft Excel generally ignores capitalized words because it usually recognizes them as Codes, Commands and Formulas; No matter how hard we try to pass the spell check, the program will not show any suggestions. To correct this we do the following:
- We go to «File» and then to «Excel Options».
- In the new dialog, we go to «Review» where we will see a marked option that says «Skip capitalized words».
- All we have to do is uncheck the box and click OK.
When you do this and go through the Excel spell checker again, you’ll notice that it will now show autocorrect suggestions, just do the same. In the Page Layout section, you can insert page numbers in the spreadsheet.
What macros can you use to correct spelling in Excel?
There are also the following possibilities Use a spell check system Even more powerful is to use an Excel VBA macro, for which you have to use the shortcut Alt + F11 to open the edit box and insert the following code:
- Sub ColorMispelledCells(); For each cl in ActiveSheet.UsedRange; If Not Application.CheckSpelling(Word:=cl.Text) Then _; cl.Interior.ColorIndex = 12; Next classification; End sub.
For each semicolon in the code above, write a separate line, then press F5 to activate the macro, and the spell check is done.