You can check the spelling of words in the cells of a worksheet and add words to the dictionary.You are only notified that a word is spelled wrong when you run the spell check.You can also press F7 with any tab on the ribbon active to start the spell check.The questionable word displays in the Not in Dictionary edit box.
You can choose to Ignore Once or to Ignore All occurrences of the misspelled word if the word is actually correct for your purposes. If thats the case, you can choose to Add to Dictionary if the word is one you use often. Then, click Change. To change all occurrences of this error with the same change, click Change All. To do this, either enter the correct word in the Not in Dictionary edit box or choose it from the Suggestions list and click AutoCorrect on the Spelling dialog box. In addition to correcting the word in your worksheet, an AutoCorrect entry is automatically created. The next time you type the incorrect word the same way, it will be automatically replaced with the replacement word you specified. Thats because its the result of a formula in that cell that grabbed the word from a cell on the Product Database worksheet based on the Item Code entered on the Invoice worksheet. To correct Refridgerator, we need to run a spell check on the Product Database worksheet, which we will do in the next section. Click Yes to check the remainder of the worksheet that has not been checked yet and then you will see the Spell check complete dialog box pictured above. But what if you have a lot of worksheets in your workbook and you want to check them all No worries. In the previous section, we only checked the Invoice worksheet. Now, we will select both of the worksheets in our workbook so they will both be spell checked without having to do each separately. When all worksheet tabs are selected, they all display with a white background, as shown below. In our case, when the spell check gets to the second worksheet, or the Product Database worksheet, it finds a spelling error. To correct the error, we select the correct word in the Suggestions list box and click Change. As we mentioned earlier in this article, if we think we misspelled the same word the same way in other cells in our workbook, we can click Change All to correct them all at once with the same corrected word. The spell check can also be limited to use of the main dictionary only, even if there are custom dictionaries available. Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business. Since we launched in 2006, our articles have been read more than 1 billion times.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |