Microsoft Office Tutorials and References
In Depth Information
Customizing and Sharing AutoCorrect Entries
Customizing and Sharing AutoCorrect Entries
Most users have encountered the Excel AutoCorrect feature — often accidentally. For example, if
you enter (c) into a cell, Excel automatically “corrects” it by substituting a copyright symbol ©.
Excel also corrects some spelling errors and other common mistakes, such as starting a word
with two initial uppercase letters.
To override an AutoCorrection, press Ctrl+Z while you’re entering information into the
cell. For example, if you need to enter (c) rather than a copyright symbol, type a
space after the (c) . Excel makes the autocorrection, but you can override it by
pressing Ctrl+Z. If you press Ctrl+Z after you make the cell entry, the entire contents of the
cell are deleted.
Fortunately, the AutoCorrect feature is highly customizable, and you can turn it off completely
if you find it annoying. You might find it worth the effort to spend some time configuring
AutoCorrect so that it works best for you. Figure 42-1 shows the AutoCorrect dialog box. To
display this dialog box, choose File
Options. Click the Proofing tab and then click the AutoCorrect
Options button. Or, just press Alt+T,A.
Figure 42-1: Use the AutoCorrect dialog box to customize the Excel AutoCorrect settings.
To add an AutoCorrect shortcut, type the shortcut text in the Replace field (for example, msft ),
and type the text that it will expand to in the With field (for example, Microsoft Corporation ). To
remove an existing shortcut, locate it in the list and click the Delete button.
Excel 2010 introduces a new twist: Math AutoCorrect. This feature lets you define shortcuts for
use with the Equation editor (accessible by choosing Insert Symbols Equation). View or adjust
these settings in the Math AutoCorrect tab of the AutoCorrect dialog box.
Search JabSto ::

Custom Search