Chapter 32: Making Your Worksheets Error-Free
673
l (^) Capitalize Names of Days: Capitalizes the days of the week. If you enter monday, Excel
converts it to Monday.
l (^) Correct Accidental Use of cAPS LOCK key: Corrects errors caused if you accidentally
pressed the CapsLock key while typing.
l (^) Replace Text as You Type: AutoCorrect automatically changes incorrect words as you
type them.
FIGURE 32.18
Use the AutoCorrect dialog box to control the spelling corrections Excel makes automatically.
Excel includes a long list of AutoCorrect entries for commonly misspelled words. In addition, it
has AutoCorrect entries for some symbols. For example, (c) is replaced with ©, and (r) is replaced
with ®. You can also add your own AutoCorrect entries. For example, if you find that you fre-
quently misspell the word January as Janruary, you can create an AutoCorrect entry so that it’s
changed automatically. To create a new AutoCorrect entry, enter the misspelled word in the
Replace box and the correctly spelled word in the With field. You can also delete entries that you
no longer need.
Tip
You also can use the AutoCorrect feature to create shortcuts for commonly used words or phrases. For exam-
ple, 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 Corporation. Just make sure that you don’t use a combination of characters
that might normally appear in your text. n