Microsoft Office Tutorials and References
In Depth Information
Eliminating Errors with Text to Speech
AutoCorrect: Click this button to have Excel automatically correct this
spelling error with the suggestion displayed in the Suggestions list box
(by adding the misspelling and suggestion to the AutoCorrect dialog
box; for more, read Chapter 2).
Dictionary Language: To switch to another dictionary (such as a United
Kingdom English dictionary, or a French dictionary when checking
French terms in a multilingual worksheet), click this drop-down button
and then select the name of the desired language in the list.
Options button to open the Proofing tab in the Excel Options dialog box
where you can modify the current Excel spell-check settings such as
Ignore Words in Uppercase, Ignore Words with Numbers, and the like.
Notice that the Excel spell checker not only flags words not found in its
builtin or custom dictionary, but also flags occurrences of double words in a cell
entry (such as total total ) and words with unusual capitalization (such as NEw
York instead of New York ). By default, the spell checker ignores all words
with numbers and all Internet addresses. If you want it to ignore all words
in uppercase letters as well, click the Options button at the bottom of the
Spelling dialog box, and then select the Ignore Words in UPPERCASE check
box before clicking OK.
You can check the spelling of just a particular group of entries by selecting the
cells before you click the Spelling command button on the Review tab of the
Ribbon or press F7.
Excel also has a Thesaurus pane that enables you to find synonyms for the
label entered into the cell that’s current when you open the pane (or that you
type into its text box). To open the Thesaurus pane, select Review Thesaurus
in the Proofing group at the beginning of the Review tab on the Ribbon or
press Shift+F7. Excel then opens a pane showing a list of all the synonyms for
the label in the current cell or the term manually entered in its text box. To
view more synonyms for a particular term in the list, select it. To replace the
label entered in the current cell with a term in the Thesaurus list, select Insert
on the term’s drop-down menu.
Eliminating Errors with Text to Speech
The good news is that Excel 2013 still supports the Text to Speech feature
introduced in Excel 2003. This feature enables your computer to read aloud
any series of cell entries in the worksheet. By using Text to Speech, you can
check your printed source while the computer reads aloud the values and
labels that you’ve actually entered — a real nifty way to catch and correct
errors that may otherwise escape unnoticed.
Search JabSto ::

Custom Search