- Click Spelling on the Standard toolbar.
- When you identify a word that you want to add to a custom dictionary, click Options in the Spelling dialog box.
- In the Add words to box, type a name for your new custom dictionary.
The following are default locations for custom dictionaries.
In Microsoft Windows 2000 or later
Custom dictionaries are stored by default in the G:\Documents and Settings\<username>\Application Data\Microsoft\Proof folder.
In Microsoft Windows Millennium Edition or Microsoft Windows 98
Custom dictionaries are stored by default in either the C:\Windows_folder\Application Data\Microsoft\Proof folder or the C:\Windows_folder\Profiles\User_name\Application Data\Microsoft\Proof folder.
Custom dictionaries are stored by default in the C:\Windows_folder\Profiles\User_name\Application Data\Microsoft\Proof folder.
Add a word to a custom dictionary
- Click Spelling on the Standard toolbar.
- When you identify a word that you want to add to a custom dictionary, click Options in the Spelling dialog box.
- In the Add words to box, click the name of the custom dictionary, and then click OK.
Note If you want to use a custom dictionary from an earlier version of Microsoft Excel, type the name of the dictionary in the Add words to box to register the dictionary with the current version of Excel.