- slide 1 of 9
If you ever accidentally typed “teh" in Word or Excel 2013, you probably noticed the misspelling automatically changed to “the." That change is the work of, which houses myriad common misspellings and allows you to add more.
As an example, say you repeatedly enter “ACME Coyote Products" before entering the product number itself. This lengthy phrase with mixed capitalization takes significantly longer to type out than say “acp." By adding an AutoCorrect entry that relates those two quoted values, you never again need to manually type out the full name. Instead, entering the short, associated phrase automatically expands to the full name.
1. Click the File tab at the top of the Excel spreadsheet.
- slide 5 of 9
- When choosing your shortened phrase, keep in mind:
- You should avoid real words or text you wouldn’t want autocorrected.
- Entering lowercase text as the shortened phrase enables the phrase to be autocorrected when you type in lowercase or uppercase, but uppercase text only autocorrects text entered with the same capitalization.
By default, Replace Text as Your Type is checked; do not uncheck this box, or the feature will no longer work.
5. Click OK to close the AutoCorrect window.