The custom dictionary editing dialog box.Īt this point you can add words to and remove words from the custom dictionary, as desired.
Excel displays a dialog box that lists all the words in the custom dictionary. If there is more than one custom dictionary listed, select the one you want to edit.Excel displays the Custom Dictionaries dialog box. Click Proofing at the left side of the dialog box.In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. If you are not comfortable using a text editor to make changes to the dictionary, you can use Excel to make the changes: This is why it is preferred that you use Notepad to edit the file, rather than a program like Word or Excel. The only thing to be careful about is that you put only one word per line, and that you don't save the file in any format except plain text. When you locate the custom dictionary, you can load it into Notepad and make any changes you want. The default name for the custom dictionary is CUSTOM.DIC, and you can search for it using the Find feature in Windows. This dictionary is nothing but a plain text file that contains the list of added words, one per line.
When you add a word to your custom dictionary, it is added to the same custom dictionary that is used by other Office applications, such as Word. When you click on the Add button in the spell-check dialog box, the word is added to your custom dictionary. Normally you do this when you run across a word that the main dictionary does not understand, but which you know is correct. As you use the spell-checking capabilities of Excel, you undoubtedly have added words to your custom dictionary.