|
When entering vast quantities of data, it's really easy for nasty little typos to creep into your work. In your pursuit of the perfect spreadsheet, here are two things you can do:
- Get Excel to automatically correct certain data entry typos right as they happen with its AutoCorrect feature.
- Manually correct any little errors that get through, either while you're still in the process of making the entry in the cell or after you've already entered the data.
The AutoCorrect feature is a godsend for those who tend to make the same typos over and over again. With AutoCorrect, you can alert Excel 2007 to your own particular typing gaffes and tell the program how it should automatically fix them for you.
When you first install Excel, the AutoCorrect feature already knows to automatically correct two initial capital letters in an entry (by lowercasing the second capital letter), to capitalize the name of the days of the week, and to replace a set number of text entries and typos with particular substitute text.
 | You can add to the list of text replacements at any time when using Excel. 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. |
To add to the AutoCorrect replacements:
1. Click Office Button --> Excel Options --> Proofing or press Alt+FIP and then click the AutoCorrect Options button or press Alt+A to open the AutoCorrect dialog box.
2. On the AutoCorrect tab in this dialog box, enter the typo or abbreviation in the Replace text box.
3. Enter the correction or full form in the With text box.
4. Click the Add button to add the new typo or abbreviation to the AutoCorrect list.
5. Click the OK button to close the AutoCorrect dialog box.
| 
