Microsoft Office Tutorials and References
In Depth Information
Fixing Those Data Entry Flub-Ups
Fixing Those Data Entry Flub-Ups
We all wish we were perfect, but alas, because so few of us are, we are best
off preparing for those inevitable times when we mess up. When entering
vast quantities of data, it’s easy for those nasty little typos to creep into your
work. In your pursuit of the perfect spreadsheet, here are things you can do.
First, get Excel to correct certain data entry typos automatically when they
happen with its AutoCorrect feature. Second, manually correct any
disgusting little errors that get through, either while you’re still in the process of
making the entry in the cell or after the entry has gone in.
You really AutoCorrect that for me
The AutoCorrect feature is a godsend for those of us who tend to make the
same stupid typos over and over. With AutoCorrect, you can alert Excel 2013
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 spelling, and abbreviations or acronyms that you type
all the time along with their full forms.
To add to the replacements, follow these steps:
1. Choose File Options Proofing or press Alt+FTP and then click the
AutoCorrect Options button or press Alt+A.
Excel opens the AutoCorrect dialog box shown in Figure 2-9.
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 or press Enter to add the new typo or
abbreviation to the AutoCorrect list.
5. Click the OK button to close the AutoCorrect dialog box.
Search JabSto ::

Custom Search