Page 115 - Excel 2013 All-in-One For Dummies

If the AutoComplete feature starts to bug you when building a particular spreadsheet, you can temporarily turn it off; simply click the Enable AutoComplete for Cell Values check box, and remove the check mark on the Advanced tab of the Excel Options dialog box (File➪Options or Alt+FTA). Note that disabling AutoComplete in this manner also disables the new Flash Fill feature. (See “Flash Fill to the rescue” later in this chapter for details.)
You AutoCorrect this right now!
Along with AutoComplete, Excel has an AutoCorrect feature that automati- cally fixes certain typos that you make in the text entries as soon as you complete them. For example, if you forget to capitalize a day of the week, AutoCorrect does this for you (turning friday into Friday in a cell as soon as you complete the entry). Likewise, if you mistakenly enter a word with two initial capital letters, AutoCorrect automatically lowercases the second capi- tal letter (so that QUarter typed into a cell becomes Quarter upon completion of the cell entry).
In addition to these types of obvious capitalization errors, AutoCorrect also automatically takes care of common typos, such as changing hsi to his (an obvious transposition of two letters) or inthe to in the (an obvious case of a missing space between letters). In addition to the errors already recognized by AutoCorrect, you can add your own particular mistakes to the list of auto- matic replacements.
To do this, open the AutoCorrect dialog box and then add your own replace- ments in the Replace and With text boxes located on the AutoCorrect tab, shown in Figure 1-7. Here’s how:
1. Select File➪Options and then click the Proofing tab (Alt+FTP) fol- lowed by the AutoCorrect Options button.
The AutoCorrect dialog box opens for your language, such as English (U.S.).
2. If the AutoCorrect options aren’t already displayed in the dialog box, click the AutoCorrect tab to display them.
3. Click the Replace text box and then enter the typo exactly as you usu- ally make it.
4. Click the With text box and enter the replacement that AutoCorrect should make (with no typos in it, please!).
Check the typo that you’ve entered in the Replace text box and the replacement that you’ve entered in the With text box. If everything checks out, go on to Step 5.
Data Entry 101 97
Book II Chapter 1
Building Worksheets