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

Looking Up and Translating Stuff 225
5. To make the new custom dictionary the default dictionary into which new words are saved, click the dictionary’s name in the Dictionary List box to select it and then click the Change Default button.
6. Click OK to close the Custom Dictionaries dialog box and then click OK again to close the Excel Options dialog box.
Excel returns you to the Spelling dialog box.
7. Click the Add to Dictionary button to add the unknown word to the new default custom dictionary and then continue spell checking your spreadsheet.
Note that Excel continues to add all unknown words to your new custom dictionary until you change the default back to the original custom diction- ary (or to another custom one that you’ve created). To change back and start adding unknown words to the original custom dictionary, select the RoamingCustom.dic file in the Custom Dictionaries dialog box and then click the Change Default button.
You can directly edit the words that you add to your custom diction-
ary. Click the Custom Dictionaries button on the Proofing tab of the Excel Options dialog box (File➪Options➪Proofing or Alt+FTP) and then click the Edit Word List command button. Excel then opens a dialog box with the default dictionary’s name that contains a Word(s) text box where you can enter new words to add to the custom dictionary and a Dictionary list box below that lists all the words added to the dictionary in alphabetical order. To add a new word to the dictionary, type it in the Word(s) text box (care- fully, you don’t want to add a misspelling to the dictionary) and then click the Add button. To remove a word, click it in the Dictionary list box and then click the Delete button.
Looking Up and Translating Stuff
In addition to the very useful Spelling button (discussed in the previous sec- tion), the Proofing and Language groups on the Review tab contains three other command buttons that can come in handy from time to time:
✦ Research opens the Research pane where you can look up text that you enter in the Search For text box or the contents of the current cell auto- matically entered into this text box.
✦ Thesaurus opens the Research pane with the Thesaurus option selected. Here you can look up synonyms for a particular term that you enter into the Search For text box or for the contents of the current cell automatically entered into this text box.
Book II Chapter 3
Editing and Proofing Worksheets