In Microsoft Word, when you make a spelling mistake in your text, Word automatically shows you that you have made a mistake by underlining the affected words with a red line.
I was asked this week to see if there was a way to get Microsoft Excel to act like Microsoft Word in the way that it recognizes spelling mistakes automatically and highlights them to bring them to your attention. After looking into this I found that unfortunately there isn’t a way to get Excel to recognize and highlight any mistakes you make whilst filling in the spreadsheet. However to correct any mistakes that you have made in Word, you can either press the F7 key on your keyboard or right click over the mistake and Word will offer you suggestions for the correct spelling.
To turn on/off this feature, follow these steps:
Click the Microsoft Office Button in the top left corner, and then click Word Options and select Proofing.
If you want to just turn the checker on for the document you are working on, do the following:
Under Exceptions for, click Name of currently open file and select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.
If you want to turn the checker on/off for all documents you create from now, do the following:
Under Exceptions for, click All New Documents and select or clear the Hide spelling errors in this document only and Hide grammar errors in this document only check boxes.
The only tool that comes close to doing this job in Excel is the Auto-correct option which can identify and correct common mistakes and typos such as replacing teh with the.
Want more tips? Click on Microsoft Word and Excel Tips.
0 Responses to “Microsoft Word & Excel Tips – Automatic Spell Checking?”
Leave a Reply