You can use Excel’s 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 Corporation.

Excel includes quite a few built-in AutoCorrect terms (mostly common misspellings), and you can add your own. To set up your custom AutoCorrect entries, access the Excel Options dialog box (choose Office Button?Excel Options) and click the Proofing 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.

FIGURE 13-6
AutoCorrect allows you to create shorthand abbreviations for text you enter often.

• Configure Microsoft Word, Excel 2007 to save file in 97-2003 format This method is recommended to prevent compatibility issue. You have an option to choose a default file format in Word...
• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Red Nag Champa - 100 Gram Box - Shanthimalai Incense User Reviews Send this to a friend Red Nag Champa - 100 Gram Box - Shanthimalai Incense Manufacturer: Shanthimalai Customer...
• The Quality Of The Text For Customers. Hi, I’ve read tons of articles closely connected with relationships between copywriters and customers. So here below I’d like to...
• Adwords Key Phrase Research For Inexperienced Persons While you embark to your first PPC adventure, you wish to have to keep a small number of keywords at...