Page 242 - Excel 2013 All-in-One For Dummies

224 Spell Checking Heaven
✦ Suggest from Main Dictionary Only: Have Excel use only the main dic- tionary when doing a spell check (thus, ignoring all words that you’ve added to a custom dictionary).
✦ Custom Dictionaries: Open the Custom Dictionaries dialog box where you can edit the words in a custom dictionary or add a new custom dic- tionary to be used in spell checking. (See “Adding words to the custom dictionary” that follows.)
✦ French Modes or Spanish Modes: Choose between the traditional or more modern spellings of French or Spanish words, respectively.
✦ Dictionary Language: Specify the language and country of the diction- ary to use when spell checking the worksheet.
Adding words to the custom dictionary
You use the Add to Dictionary button in the Spelling dialog box to add unknown words to a custom dictionary. By default, Excel adds words to a custom dictionary file named RoamingCustom.dic. This file is located in the UProof folder, which is located within the Microsoft folder inside the Application Data folder. The Application Data folder is either inside the Windows User folder on your C: drive or, if you’re on a network, this file may be located in your username folder inside the Profiles folder that lies within the Windows folder on your C: drive.
If you want, you can create other custom dictionaries to use when spell checking your worksheets. To create a new custom dictionary, follow these steps:
1. Click the Custom Dictionaries button in the When Correcting Spelling in Microsoft Office Programs section of the Proofing tab.
Excel opens the Custom Dictionaries dialog box, where you can create a new custom dictionary to use.
2. Click the New button in the Custom Dictionaries dialog box. Excel opens the Create Custom Dictionary dialog box.
3. Type the name for your new custom dictionary and then click the Save button.
After the Create Custom Dictionary dialog box closes, the name of the custom dictionary you created appears underneath CUSTOM.DIC (Default) in the Dictionary List box.
4. (Optional) To restrict the language of a custom dictionary, select the language from the Dictionary Language drop-down list after clicking the dictionary’s name in the Dictionary List box to select it.