© 2010 CustomGuide, Inc.
Using and Customizing
AutoCorrect automatically corrects many common typing
and spelling errors as you type. It is also a great way to
use shorthand for longer words, phrases, or symbols.
AutoCorrect is a feature that is shared across the
Microsoft Office suite
so any additions or changes you
make to AutoCorrect in one program, such as Word, will
appear in all Microsoft Office programs, like Excel,
Excel, and Outlook.
How AutoCorrect works
You may have already noticed that sometimes your typos
are corrected as you enter text in Word. When you type an
AutoCorrect entry and then press the <Spacebar>,
AutoCorrect replaces that text with the correct text.
For example, AutoCorrect will change the mistyped
words “hte” to “the”, or “adn” to “and”. AutoCorrect also
corrects simple grammar mistakes, such as capitalization
problems. For example, it would change “GOing” to
“Going,” or capitalize the first letter in sentences.
Create an AutoCorrect entry
Excel already has many entries in AutoCorrect, but you
can add your own entries to correct habitual misspellings,
quickly insert a symbol, or insert a shorthand version of a
long phrase that you frequently use.
1. Click the File tab and select Options.
The Excel Options dialog box appears.
2. Click the Proofing tab.
This tab displays options for how Excel corrects and
3. Click the AutoCorrect Options button.
The AutoCorrect dialog box appears with the
AutoCorrect tab in front.
4. Type the word or phrase you want to correct or use as
shorthand in the Replace text box.
This is the text that AutoCorrect will recognize when
5. Type the word or phrase you want to appear in the
With text box.
When the text in the “Replace” text box is typed with
a space, the text in the “With” text box will appear.
Exercise File: None required.
Create an AutoCorrect entry that replaces “ot”
Try the AutoCorrect entry with this phrase, “He was going
ot the store.”
Figure 14-5: An example of how AutoCorrect works.
Figure 14-6: The AutoCorrect tab of the AutoCorrect
He was going ot
He was going to