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.

• How to: Protect your email from Spam Bots in Blogs, Social Sites, Forums and Websites A spambot is a web crawler program designed to crawl and search for a website and collect the email address...
• 5 Ways to Print Folder and Directory Contents in Windows Bookmark this category 5 Ways to Print Folder and Directory Contents in Windows It’s one of those simple tasks that...
• Must Have Blogging Tools Blogging has developed a serious place for itself in the internet community for many different purposes including personal use and...
• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• 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...