Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
Using AutoCorrect for shorthand data entry
You can use the AutoCorrect feature to create shortcuts for commonly used words or
phrases. For example, if you work for a company named Consolidated Data Processing
Corporation, you can create an AutoCorrect entry for an abbreviation, such as cdp. Then,
whenever you type cdp , Excel automatically changes it to Consolidated Data Processing
Excel includes quite a few built-in AutoCorrect terms (mostly to correct common
misspellings), and you can add your own. To set up your custom AutoCorrect entries, access the
Excel Options dialog box (choose File
Options) and click the Prooﬁ ng tab. Then click
the AutoCorrect Options button to display the AutoCorrect dialog box. In the dialog box,
click the AutoCorrect tab, check the option labeled Replace Text as You Type, and then
enter your custom entries. (Figure 13.6 shows an example.) You can set up as many custom
entries as you like. Just be careful not to use an abbreviation that might appear normally
in your text.
AutoCorrect allows you to create shorthand abbreviations for text you enter often.
Excel shares your AutoCorrect list with other Microsoft office applications. For example, any AutoCorrect entries you
created in Word also work in Excel.