Pin Me

Using AutoCorrect to Speed up Data Entry in Excel 2013

written by: •edited by: Tricia Goss•updated: 12/22/2015

Microsoft Office's AutoCorrect feature enables you to add custom entries manually. You can capitalize on the option for customization by reducing complicated, frequently entered text to just a few letters, which could dramatically speed up data entry.

  • 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 2 of 9

    2. Click Options from the left pane.

  • slide 3 of 9

    3. Click Proofing from the left pane and select the AutoCorrect Options button in the right pane.

  • slide 4 of 9

    4. Enter the shortened phrase in the Replace field and the expanded text in the With field of the AutoCorrect tab, and then click Add.

  • slide 5 of 9
    1. 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.

  • slide 6 of 9

    6. Click OK to close the Excel Options window.

  • slide 7 of 9

    7. Enter the shortened phrase in a cell.

  • slide 8 of 9

    Nothing will happen until you move to the next word or cell.

    8. Press Enter, type a space or navigate away with an arrow key; Excel will then replace the shortened phrase with the full text.

  • slide 9 of 9

    Note that the shortened phrase cannot include additional letters. In this example, “acp,” “ACP” or even “aCp” autocorrects to the full text, but “acpa” would not.

Additional Info