<

Go Premium for a chance to win a PS4. Enter to Win

x

How to tell Microsoft Office that a word is NOT spelled correctly

Posted on
11,195 Points
796 Views
14 Endorsements
Last Modified:
Experience Level: Beginner
4:56
Joe Winograd, EE MVE 2015&2016
50+ yrs in computer industry. Everything from programming to sales. OS kernel dev on mainframes. CIO. Document imaging. EE MVE 2015 & 2016.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When an Office module, such as MS Word, gives us the red squiggly underline signifying a misspelled word, yet it really is spelled correctly (such as a proper noun), we're all familiar with how to add it to the custom dictionary, that is, simply right-click the word and select Add to Dictionary. But suppose we type in a word that does not get the red squiggly underline, that is, Word thinks it is spelled correctly, yet we do not like that spelling, and we want Word (and other Office apps) to flag it as a misspelling. This video explains a Microsoft supported technique for achieving that.

Video Steps

1. Locate the ExcludeDictionary file


Exit all Office apps.

Using Windows/File Explorer (or whatever file manager you prefer), navigate to this file:

c:\Users\<username>\AppData\Roaming\Microsoft\UProof\ExcludeDictionaryEN0409.lex

Of course, <username> is your user name (in my video, it is Joe). The exact name of the file will vary depending on your language and Office version, but it will begin with ExcludeDictionary and have a LEX file extension.

Step1

2. Open the ExcludeDictionary file


Using Notepad (or whatever plain text editor you prefer), open the ExcludeDictionary file, which will be empty the first time you open it. If you do a File>Open, make sure that All Files is selected, since it is a LEX file, not a TXT file. Another technique is simply to drag-and-drop it from your file manager into your text editor.

Step2

3. Enter words in the ExcludeDictionary file


Enter the words that you want Office to consider NOT spelled correctly into the ExcludeDictionary file, each word on a separate line.

Step3

4. Save the modified ExcludeDictionary file and test


Save the modified ExcludeDictionary file.

Open Excel, Outlook, PowerPoint, Word, or whatever Office app you want to test, and type in the words that you entered in the ExcludeDictionary file. They should now be flagged as misspelled.

Step4
If you find this video to be helpful, please click the thumbs-up icon below. Thank you for watching!
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

14
Comment
  • 2
  • 2
4 Comments
 

Expert Comment

by:baffledbill
Joe, this is a great tip and very clearly presented.

I notice I have multiple .lex files, apparently for various languages (EN, FR, GE, etc). However, I also have multiple EN files: EN0409.lex, EN0809.lex, EN1009.lex. They are all empty. Do you know why this would be, and how I would know which one to use?

Thanks!
0
 
LVL 56

Author Comment

by:Joe Winograd, EE MVE 2015&2016
Hi Bill,
First, thanks for the compliment — I appreciate it! The two-letter code is for Language and the four-character code is what Microsoft calls the Locale ID (in the LEX file name, it is in hexadecimal). For example, EN is English, while 1009 is English/Canada, 0809 is English/United Kingdom, 0409 is English/United States, etc. Likewise, FR is French, DE is German, ES is Spanish, etc. The two-letter codes follow the ISO 639-1 standard:
https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

You don't really need both the two-letter code and four-character code, since the latter embodies both the language and the region, but I guess Microsoft wants to give us a visual indicator in the file name on its language without having to look up the hexadecimal Locale IDs, which are here:
https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

The first Locale ID column in that list is hexadecimal, which is what MS uses in the LEX file name (the second Locale ID column in that list is decimal).

So, back to your question. The reason you have those three LEX files is that you've utilized English for Canada (1009), UK (0809), and US (0409). You would use the LEX file that makes sense for the document(s) you're editing. Regards, Joe
0
 

Expert Comment

by:baffledbill
Thank you for the detail and writing it in an understandable way.

Based on your information, I played around with the various English files and my locale and language settings and saw it work as you suggested. I also found that it is safe to simply delete the files, and let Office recreate the appropriate one when it performs a spell check.
0
 
LVL 56

Author Comment

by:Joe Winograd, EE MVE 2015&2016
You're welcome, Bill. I'm glad to hear that it works for you. And thanks to you for determining that it is safe to delete the LEX file(s) — that Office will re-create the appropriate one when it performs a spell check. I hadn't tried that — very good to know! Regards, Joe
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month