Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

Excel 2007's AutoCorrect feature already knows to automatically fix two initial capital letters in an entry, to capitalize the names of the days of the week, and to replace a set number of text entries and typos with particular substitute text. But you can use AutoCorrect to alert Excel to your own particular typing errors and tell the program how it should automatically fix them for you.

You can add to the list of AutoCorrect text replacements at any time. These text replacements can be of two types: typos that you routinely make (along with the correct spellings), and abbreviations or acronyms that you type all the time (along with their full forms). Follow these steps:

Click the Office button and then click the Excel Options button.

The Excel Options dialog box appears.

Click the Proofing tab.

Click the Proofing tab.

The Proofing options appear in the right pane.

Click the AutoCorrect Options button.

Click the AutoCorrect Options button.

The AutoCorrect dialog box appears.

Select the Replace Text as You Type check box.

This check box is usually selected by default.

On the AutoCorrect tab, enter the typo in the Replace text box.

You also can enter an abbreviation here. Be sure that the text you type in the Replace box of the AutoCorrect dialog box isn’t a real word! Otherwise, you may unintentionally replace a commonly known word with other unwanted text.

Enter the correction in the With text box.

Enter the correction in the With text box.

If you entered an abbreviation in the previous step, enter the full form of the text here.

Click the Add button and then click OK two times.

The new typo or abbreviation appears in the AutoCorrect list, and both dialog boxes close.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: