If the same word or text is found again on the worksheet then, it will be ignored. Ignore All - This ignores all the occurrences of the word displayed in the "Not in Dictionary" box. The next time the Spelling is checked on this worksheet this word will still be identified as being unknown.
If the same word or text is found again on the worksheet then it will be identified as another mistake. Ignore Once - This ignores just this occurrence of the word displayed in the "Not in Dictionary" box. You can replace the word with a suggestion by selecting one from the list and pressing the "Change" button. Suggestions - This displays a list of similar words or words which Excel thinks are likely replacements. You can edit this word directly to replace it with a different word. Not in Dictionary - This displays any words that cannot be found in the active dictionary. If you get annoyed with this prompt you can click "Add" to permanently add it to your dictionary. If the word you type is not in the directory then you are prompted to confirm. If the spell checker does not have any suggestions then you can type in your own correct and select "Change". The Spelling dialog box will open displaying the first word that cannot be found in the active dictionary.Īny cells that are hidden, including those in outlines will also be checked although any cells containing formulas will not be. This searches all your slides, not just the active one. You can select (Tools > Spelling) when only one cell is selected to check the entire worksheet. It is possible to check individual words within a cell by highlighting the words in the formula bar before displaying the (Tools > Spelling) dialog box. If the formula bar is active then Excel checks just the contents of the formula bar. You can check the contents of an individual cell by double-clicking on the cell or by pressing F2 before selecting (Tools > Spelling). Highlighting a range of cells before displaying the Spelling dialog box will mean only those cells are checked. If you select a single cell, the entire worksheet will be checked, including hidden cells, comments, chart and graphic objects and headers & footers. If you want to check the spelling on the whole workbook you must select all the worksheets first. It will not check that they are in the correct order and that the sentence or bullet necessarily makes any sense.Įxcel will only check the spelling on the active worksheet.
The spell checker will only check that the words appear in the dictionary. Using the spell checker should not a be a substitute for reading through your presentation before you present it. Spelling - This can be found on the Standard toolbar.Īlternatively you can also select (Tools > Spelling) or you can use the shortcut key (F7). There are several ways you can display the Spelling dialog box and the easiest one is to use the button on the Standard toolbar. It is definitely always worth checking your text for any spelling mistakes and this can be done easily using the Spelling dialog box. The AutoCorrect feature helps you to fix common typing errors before they become actual spelling mistakes.
0 kommentar(er)
