Editing Custom Dictionaries

As you use the spell-checking capabilities of Excel, you undoubtedly have added words 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. When you click on the Add button in the spell-check dialog box, the word is added to your custom dictionary.

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. This dictionary is nothing but a plain text file that contains the list of added words, one per line. The default name for the custom dictionary is Custom.dic, and you can search for it using the Find feature in Windows.

When you locate the custom dictionary, you can load it into Notepad and make any changes you want. 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. This is why it is preferred that you use Notepad to edit the file, rather than a program like Word or Excel.

If you are not comfortable using a text editor to make changes to the dictionary, you can use Word to make the changes. (You can't do it in Excel before Excel 2007; those versions don't provide the ability to edit the custom dictionary, even though it uses the same one as Word.) Follow these steps from within Word—provided you are using a version of Word prior to Word 2007:

1. Choose Options from the Tools menu. Word displays the Options dialog box.
2. Make sure the Spelling & Grammar tab is displayed. (Click here to see a related figure.)
3. Click on the Dictionaries button (in some versions of Word it is the Custom Dictionary button).
4. In the list of dictionaries, select the one you want to edit.
5. Click the Edit or Modify button. The dictionary is opened, as a document, and you can make changes to it.
6. Close the dictionary document when you are through editing it.

If you are using Excel 2007, you have a way to edit the custom dictionary. Follow these steps:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. Click Proofing at the left side of the dialog box.
3. Click the Custom Dictionaries button. Excel displays the Custom Dictionaries dialog box.
4. Click Edit Word List. Excel displays a dialog box that lists all the words in the custom dictionary. (Click here to see a related figure.)

At this point you can add words to and remove words from the custom dictionary, as desired. When you are done, just close all the dialog boxes and go back to using Excel.