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

✦ Click the Add to Dictionary button to add the unknown word to a custom dictionary so that Excel will know the word the next time you spell- check the worksheet.
✦ Click the AutoCorrect button to have Excel add the unknown word to the AutoCorrect list with the selected suggestion as its automatic replacement.
Keep in mind that Excel checks the spelling of the cells only in the current worksheet (and not all the sheets in the workbook). If you want Excel to spell check another worksheet, you need to click its sheet tab to make it active and then click the Spelling button on the Review tab (or press F7). If you want to spell check just a portion of the worksheet, select the range or nonadjacent cell selection before you start the spell check.
When Excel finishes checking the current worksheet or cell selection, the program displays an alert dialog box that indicates that the spell checking has been completed.
Changing the spelling options
When you use the Spell Check feature, you can change certain spelling options to better suit the spreadsheet that you’re checking. To change
the spelling options, click the Options button at the bottom of the Spelling dialog box. This action opens the Proofing tab of the Excel Options dialog box with the following options in the When Correcting Spelling in Microsoft Office Programs section:
✦ Ignore Words in UPPERCASE: Remove the check mark from the check box so that Excel marks acronyms and other words entered in all upper- case letters as misspellings.
✦ Ignore Words That Contain Numbers: Remove the check mark from the check box so that Excel marks words such as B52 that contain letters and numbers as misspellings.
✦ Ignore Internet and File Addresses: Remove the check mark from the check box so that Excel marks web URL addresses such as www. dummies.com and file pathnames such as c:\documents\finance as misspellings.
✦ Flag Repeated Words: Remove the check mark so that Excel no longer marks repeated words such as Bora Bora as misspellings.
✦ Enforce Accented Uppercase in French: Add a check mark so that Excel marks uppercase French words that don’t have the proper accent marks as misspellings.
Spell Checking Heaven 223
Book II Chapter 3
Editing and Proofing Worksheets