Create a custom dictionary

Microsoft Office Excel 2003

  1. Click Spelling Button image on the Standard toolbar.
  2. When you identify a word that you want to add to a custom dictionary, click Options in the Spelling dialog box.
  3. In the Add words to box, type a name for your new custom dictionary.

    The following are default locations for custom dictionaries.

    ShowIn Microsoft Windows 2000 or later

    Custom dictionaries are stored by default in the G:\Documents and Settings\<username>\Application Data\Microsoft\Proof folder.

    ShowIn 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.

    ShowIn Microsoft Windows NT 4.0

    Custom dictionaries are stored by default in the C:\Windows_folder\Profiles\User_name\Application Data\Microsoft\Proof folder.

ShowAdd a word to a custom dictionary

  1. Click Spelling Button image on the Standard toolbar.
  2. When you identify a word that you want to add to a custom dictionary, click Options in the Spelling dialog box.
  3. 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.