<

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

Posted on
11,244 Points
844 Views
14 Endorsements
Last Modified:
Approved
Experience Level: Beginner
4:56
Joe Winograd, Fellow&MVE
50+ years in computer industry. Everything from development to sales. CIO. Document imaging. EE MVE 2015, EE MVE 2016, EE FELLOW 2017.
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!
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 59

Author Comment

by:Joe Winograd, Fellow&MVE
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 59

Author Comment

by:Joe Winograd, Fellow&MVE
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

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Join & Write a Comment

Learn how to Syncronize all of your Outlook Contacts, Tasks, and Calendar entries with the Free copy of Gmail - you don't need a G-Suite subscription and this article will tell you how to do it! Different profiles can be set up too! Enjoy!
Learn to delete duplicate emails from Outlook 2016, 2013 & 2010 using three effective and easy methods. Also, know what are the reasons that cause these duplicates in Outlook. With these proven inbuilt methods, you can improve performance of your Ou…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month