The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that doesn't fit your needs. Fortunately, Excel autocorrect rules can be customized!
The AutoComplete options dialog can be accessed from Excel Options.
Excel 2010 and newer versions:
File > Options > Proofing > AutoCorrect Options
Office button > Options > Proofing > AutoCorrect Options
Before we begin, note that AutoCorrect options are available in all Office products, and any changes will apply to all Office product. This means that if you disable Capitalize names of days option in Excel, the same setting will also apply to Word.
AutoCorrect Options button
The first option is Show AutoCorrect Options buttons. The Autocorrect Options button isn't shown in Excel by default, but this option is listed in other Office products.
The next four options are rules for capitalization. Most options are pretty self-explanatory.
- Correct TWo INitial CApitals
- Capitalize first letter of sentence
- Capitalize names of days
- cAPS LOCK key
This is the last option in the dialog as well as caption of frame with inputs and table of strings: Replace text as you type. The table lists string pairs that define the rules for auto-correction. If you type in a string in the left column, Excel will convert it to the string at the same row and right column. For example,
(c) becomes ©,
(e) becomes €,
Also, you can see that the table contains rules to correct typo errors. Excel allows you to add your own rules or remove existing ones. Fill in the Replace and With boxes to set the correction you want, and click the Add button.
To remove a correction rule, just select the row you want to remove and click Delete. Below are some samples that show how you can use the AutoCorrect to insert symbols:
- The AutoCorrect does not work in formulas or hyperlinks.
- Every change you made in Excel AutoCorrect options applies to all workbooks and Office products.
- Press Ctrl + Z to cancel auto-correction at any time.