Excel: Use AutoCorrect to Enable a Shortcut

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I work for John Jacob Jingleheimer Schmidt. It is frustrating to type this name continuously. How can I save time?

Strategy: You can set up an AutoCorrect entry to replace JJJS with John Jacob Jingleheimer Schmidt. Here's how:

  1. Select File, Options, Proofing, AutoCorrect Options or Alt+T+A.
  2. On the AutoCorrect dialog, go to the AutoCorrect tab.
  3. In the Replace section, type JJJS. In the With section, type the complete name. Click Add.

  1. Add your own shortcut as an AutoCorrect option.

    Results: When you type JJJS in a cell, and then type a space or press Enter, Excel will replace your text with the complete text specified in the AutoCorrect list.

  2. Type the shortcut"¦

  3. "¦and a space to invoke the correction.

    Additional Details: If you sometimes need to use the abbreviation and sometimes need to spell out the words, then set up JJJS> to be the shortcut for spelling out the words. Then, when you type JJJS, the initials will appear. When you type JJJS>, the words will appear.


For more resources for Microsoft Excel